Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a workbook with dates
I have a workbook with five worksheets representing the days of the week
(M-F). I want to able to enter the date on the first worksheet (Monday) and have the correct following date be automatically inserted onto each following worksheet for that week. -- Lee Davenport |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a workbook with dates
You can use a formula
=IF(A1="","",A1+1) where A1 holds the 1st date, the formula will add 1 to the date if you set it up nicely you should just be able copy the formula across/down and it will increment by one, otherwise you can copy a cell using right click mouse and when you release it you'll be prompted to select for instance weekdays, it's not automatic but easy and fast -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Lee" wrote in message ... I have a workbook with five worksheets representing the days of the week (M-F). I want to able to enter the date on the first worksheet (Monday) and have the correct following date be automatically inserted onto each following worksheet for that week. -- Lee Davenport |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Track Annual Inspection Due Dates Using Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting with Dates | Excel Worksheet Functions | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
how do I keep a large workbook from losing all formatting upon cl. | Setting up and Configuration of Excel |