| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Date() function then adding 1 day to it.
I am trying to use Excel to create a spreadsheet for each day of the month. So for the first day, the formula i have in field A1 is: =DATE(YEAR(NOW()),MONTH(NOW()),DAY(1)) The second day, the formula i have in field A2 is: =DATE(YEAR(NOW()),MONTH(NOW()),DAY(1)+2) How do i make it so that it can take the date from the previous and add 1 to it? At the end i just want a simple formula which will automatically take the first of every month and add 1 day to it. So eventually i will have something like this: 01/01/2006 02/01/2006 03/01/2006 .... ... 31/01/2006 Many thanks in advance. James -- Jim9980 ------------------------------------------------------------------------ Jim9980's Profile: http://www.excelforum.com/member.php...o&userid=30583 View this thread: http://www.excelforum.com/showthread...hreadid=502303 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding the IF function to a VLOOKUP function. | Excel Discussion (Misc queries) | |||
| Adding days to a date cell to get a new date | Excel Worksheet Functions | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| Adding a date to calender to automatially generate another date? | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Threaded Mode
