View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NeSchw6G NeSchw6G is offline
external usenet poster
 
Posts: 15
Default Find the First of the Month after 60 days

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,