The date ??
 

In cell b2 i manually input the date as Feb 15th 2007

then in cell b40 (for example) I need the next days date

in cell B72 I need the next days date and so on.....................

basically B2 = Mondays date
B40 is Tuesdays date
B72 is Wednesday
etc upto and including Saturday


Is there a way of me manually inputting Mondays date and then the rest being
done automatically.....

It does sound simple compared to some of the requests on here.........


All help appreciated

Dave :)

The date ??
 

Dates are stored as numbers starting with 1/1/1900. So, if cell B2 has a
date (any date), then in B40 enter =B2+1 to get the date of the next day.
Or +2 for the date two days from that in B2, or -10 for the date 10 days
before than in B2, etc.

In article , db002a3121
@blueyonder.co.uk says...
In cell b2 i manually input the date as Feb 15th 2007

then in cell b40 (for example) I need the next days date

in cell B72 I need the next days date and so on.....................

basically B2 = Mondays date
B40 is Tuesdays date
B72 is Wednesday
etc upto and including Saturday


Is there a way of me manually inputting Mondays date and then the rest being
done automatically.....

It does sound simple compared to some of the requests on here.........


All help appreciated

Dave :)





--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

The date ??
 

b40 = B2+1
b72=B2+2
etc ...

Corey....
"DB" wrote in message
.uk...
In cell b2 i manually input the date as Feb 15th 2007

then in cell b40 (for example) I need the next days date

in cell B72 I need the next days date and so on.....................

basically B2 = Mondays date
B40 is Tuesdays date
B72 is Wednesday
etc upto and including Saturday


Is there a way of me manually inputting Mondays date and then the rest
being done automatically.....

It does sound simple compared to some of the requests on here.........


All help appreciated

Dave :)

The date ??
 

Spot on folks.........

Cheers again........

Dave :)))))))))))))))))))))))

P.S. I think i'm 99.9 sure my project is over now......................

PPS........just had a phonecall..............a request to alter the sheet
showing 40 duties instead of the current 26..........

ARRRRRRRRRRRRRGGGGGGGGGGHHHHHHHHHHHHHHHH!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!