incrementing a date that the user has entered?

[pano]

Hi,
in A1 the user types a date, I then need a formula in b1 which takes
the date the user has entered and increments by one day across c1 d1 e1
f1.

The day the user enters will always be a monday thru to Saturday.
A1 B1 C1 D1 E1
USER Auto Fill AUto Fill Auto Fill etc
22-Jan-07 23-Jan-07 24-Jan 07 25-Jan-07


Thanks

 

[Mike G]

Simple solution...in B1 enter =a1+1. grab handle afterwards and drag
across.

 

[Max]

In B1: =IF(A1="","",A1+1)
Copy B1 across to F1

 

[Martin Fishlock]

Hi Pano:

=IF(A1="","",A1+1--(WEEKDAY(A1,1)=7))

But this in B2 and then copy across.

Ie it assumes that you don't want a Sunday.

 

[pano]

Martin this works really well

=IF(A1="","",A1+1--(WEEKDAY(A1,1)=7))

thanks
stephen