View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_1166_] Rick Rothstein \(MVP - VB\)[_1166_] is offline
external usenet poster
 
Posts: 1
Default Find the First of the Month after 60 days

You can use this formula...

=DATE(YEAR(F3+60),MONTH(F3+60)+1,1)

Rick


"NeSchw6G" wrote in message
...
I need help making a formula to use the date in cell F3, add 60 days and
then
find the first of the following month.

i.e. The date given would be 8/21/08 and I would need a formula to produce
11/1/08

If the 60 days falls on the first of the month, then it should produce the
same number, as in the date given would be 9/2/08 and 60 days would be
11/1/08 and so it should produce 11/1/08.

Thank you,