View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Find the First of the Month after 60 days

Hi,

Try this

=IF(DAY(F3+60)=1,F3+60,EOMONTH(F3+60,0)+1)

If you get a NAME error then
Tools|Addins
Check the analysis toolpak and re=enter the formula

Mike

"NeSchw6G" wrote:

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,