| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
set a date in columns 7 days apart
How can I set a date in subsequent columns that are 7 days apart? I have
tried =DAY(IF(B3="","",B3+7)) but if given a date March 6, 2005 it will show 31 days in April. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns | Excel Discussion (Misc queries) | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
| Having a due date flag in a different colour 30 days from current. | Excel Worksheet Functions | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Threaded Mode
