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,
|