Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edate Formula
I am using the edate formula edate(A1,1). Cell A1 is 01/31/2006. The next date is 02/28/2006 however all subsequent days are now the 28th of each month, not the actual last day of the month. Can you please advise how I can correct this formula? -- ROSE2102 ------------------------------------------------------------------------ ROSE2102's Profile: http://www.excelforum.com/member.php...fo&userid=9202 View this thread: http://www.excelforum.com/showthread...hreadid=503441 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edate Formula
Hi Rose
Instead of letting A1 increment as you copy down, hold A1 constant with the absolute reference $A$1 and let the increment increase by using ROW(1:1). In A2 =$A$1+ROW(1:1) As you copy down, row will increment by 1 each time and you will get the correct end of month for the whole tear. -- Regards Roger Govier "ROSE2102" wrote in message ... I am using the edate formula edate(A1,1). Cell A1 is 01/31/2006. The next date is 02/28/2006 however all subsequent days are now the 28th of each month, not the actual last day of the month. Can you please advise how I can correct this formula? -- ROSE2102 ------------------------------------------------------------------------ ROSE2102's Profile: http://www.excelforum.com/member.php...fo&userid=9202 View this thread: http://www.excelforum.com/showthread...hreadid=503441 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edate Formula
If you're looking for last days of months, then how about using the EOMONTH
function instead? =EOMONTH(A1,1) That would return 2/28/06 =EOMONTH(A1,2) Returns 3/31/06 HTH, Elkar "ROSE2102" wrote: I am using the edate formula edate(A1,1). Cell A1 is 01/31/2006. The next date is 02/28/2006 however all subsequent days are now the 28th of each month, not the actual last day of the month. Can you please advise how I can correct this formula? -- ROSE2102 ------------------------------------------------------------------------ ROSE2102's Profile: http://www.excelforum.com/member.php...fo&userid=9202 View this thread: http://www.excelforum.com/showthread...hreadid=503441 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |