Adding 2weeks and rounding up to EOM
Perfect - thank you.
"jaf" wrote:
Hi Micki,
=EOMONTH(G11+14,0) should do the trick.
John
"Micki" wrote in message ...
I need to add 2 weeks to a date and round it up to the last day of the month.
G11: 6/15/2009
Add 2 weeks, but round to 6/30/2009
If I add 14 days to 6/15/2009, it returns 6/29/2009
Thank you.
|