incrementing a date that the user has entered?

P

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
 
M

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.
 

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