incrementing a date that the user has entered?
 

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

incrementing a date that the user has entered?
 

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

"pano" wrote in message
ups.com...
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

incrementing a date that the user has entered?
 

In B1: =IF(A1="","",A1+1)
Copy B1 across to F1
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
pano wrote:
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

incrementing a date that the user has entered?
 

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.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"pano" wrote:

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

incrementing a date that the user has entered?
 

Martin this works really well

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

thanks
stephen


Martin Fishlock wrote:
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.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"pano" wrote:

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