|
How to generate dates for a month?
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=502759 |
How to generate dates for a month?
James,
Here's one solution, down the page at #13: http://www.dicks-blog.com/archives/2...ugly-formulas/ NickHK "Jim9980" wrote in message ... 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=502759 |
How to generate dates for a month?
in A1
=Today() in A2 =A1+1 format both cells as Date select A2 and drag fill down -- Regards, Tom Ogilvy "Jim9980" wrote in message ... 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=502759 |
How to generate dates for a month?
The forumla does not copy. -- Jim9980 ------------------------------------------------------------------------ Jim9980's Profile: http://www.excelforum.com/member.php...o&userid=30583 View this thread: http://www.excelforum.com/showthread...hreadid=502759 |
| All times are GMT +1. The time now is 02:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com