| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 :) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| copy date based on date -refer to date range | Excel Programming | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
