Thread: Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Dates

You might try
=DATE(YEAR(A1+30),MONTH(A1+30)+1,1)
=DATE(YEAR(A1)+1,CEILING(MONTH(A1),3)+1,0)+1
--
David Biddulph

"Jody" wrote in message
...
I need to calculate a date and need help...
Enter a hire date in one cell and then I need to calculate 1st of the
following month after 30 days?
Enter a hire date in one cell and then I need to calculate 1st of the
following quarter after 1 year?
For some reason I am brain dead today - if anyone could help - it would be
greatly appreciated.