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.