View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
user@msn user@msn is offline
external usenet poster
 
Posts: 2
Default date calculation

I need a formula that will return the last day of the month for a period of
two months prior to the date I enter. For example, if I enter 1/1/08 in Cell
A1, I want Cell B1 to return 11/30/07; if I enter 2/1/08 in Cell A1, I want
Cell B1 to return 12/31/07, etc..

P.S. Cell A1 will always be the first day of the month (if that matters)

Thanks