Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"edate" problem with calculating dates
I use the "edate" function in Excel to determine the first day of the month
going back from a termination date...for example: If a lease ends March 31, 2007 we need written notice by January 1, 2007 so I want Excel to automatically calculate the 01/01/07 date by going back from March 31, 2007. The "edate" function works for all months in a year except for two....and I'm sure it's because of Feb. having only 28 days and July/August having 31 each. Can anyone help troubleshoot this or let me know of another function that will achieve the result I am looking for. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"edate" problem with calculating dates
How's about...
=EOMONTH(A1,-3)+1 "MMangen" wrote: I use the "edate" function in Excel to determine the first day of the month going back from a termination date...for example: If a lease ends March 31, 2007 we need written notice by January 1, 2007 so I want Excel to automatically calculate the 01/01/07 date by going back from March 31, 2007. The "edate" function works for all months in a year except for two....and I'm sure it's because of Feb. having only 28 days and July/August having 31 each. Can anyone help troubleshoot this or let me know of another function that will achieve the result I am looking for. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"edate" problem with calculating dates
You are awesome, that worked perfectly! Tested, tried and true! Thanks again
so much. It's been "haunting" me! "Teethless mama" wrote: How's about... =EOMONTH(A1,-3)+1 "MMangen" wrote: I use the "edate" function in Excel to determine the first day of the month going back from a termination date...for example: If a lease ends March 31, 2007 we need written notice by January 1, 2007 so I want Excel to automatically calculate the 01/01/07 date by going back from March 31, 2007. The "edate" function works for all months in a year except for two....and I'm sure it's because of Feb. having only 28 days and July/August having 31 each. Can anyone help troubleshoot this or let me know of another function that will achieve the result I am looking for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem calculating percent change | Excel Worksheet Functions | |||
Circular Reference Problem Calculating Net Pay | Excel Worksheet Functions | |||
add/subtract dates problem in Excel..... | Excel Discussion (Misc queries) | |||
calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
Calculating for number of days when values are in dates | Excel Worksheet Functions |