Calculate a Date
Hi,
You could use the formula:
=EOMONTH(A1,24-(DAY(A1)=1))+1
The EOMONTH function is part of the Analysis ToolPak which in Excel 2003 or
earlier, you can attach by choosing Tools, Add-ins, Analysis ToolPak.
Cheers,
Shane Devenshire
Microsoft Excel MVP
"Mac55" wrote in message
...
How would you dtermine a date 2 years into the future and taken to the 1st
of
the following month if that date does not occur on the 1st of the month.
For example, hire date is 7/18/08 and I want determine a promotion date
that
is 2 years from the hire date. Then because we only give promotions on
the
1st day of the month, the example promotion date would be 8/1/10.
What formula would I use to automatically calculate this?
New to date functions.
|