Schedule Events

S

Steve Walford

People have helped on here in the past, I wonder if the can help with
this

I am trying to automate a schedule of future events at 6 weekly
intervals (42 days) all except the final event. Seed date is a weekday
Mon - Fri


Columns A and B

Format, apologises for european date format

Column A Column B
dd/mm/yyyy DDD


Formula

A1 input seed date
A2 = A1 +42 continues for 10 events

B1 = A1
B2 = A2

Dates calculated for twelve months


Example

A1 Seed date 05/07/2010

Output

16/08/2010
27/09/2010
08/11/2010
20/12/2010
31/01/2011
14/03/2011
25/04/2011
06/06/2011
18/07/2011

All days are Mondays

I want the final event cell 18/07/2010 to calculate the Friday of the
previous week

I hope I have made myself clear

Thanks in anticipation


Steve
 
D

Don Guillett Excel MVP

People have helped on here in the past, I wonder if the can help with
this

I am trying to automate a schedule of future events at  6 weekly
intervals (42 days) all except the final event. Seed date is a weekday
Mon - Fri

Columns A and B

Format, apologises for european date format

Column A            Column B
dd/mm/yyyy      DDD

Formula

A1   input seed date
A2 = A1 +42 continues for 10 events

B1 = A1
B2 = A2

Dates calculated for twelve months

Example

A1 Seed date 05/07/2010

Output

16/08/2010      
27/09/2010                
08/11/2010
20/12/2010
31/01/2011
14/03/2011
25/04/2011
06/06/2011
18/07/2011

All days are Mondays

I want the final event cell 18/07/2010 to calculate the Friday of the
previous week

I hope I have made myself clear

Thanks in anticipation

Steve

This should do the last date as 15 July

=(F9+42)-CHOOSE(WEEKDAY(F9+42),2,3,4,5,6,7,1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top