Adding 2weeks and rounding up to EOM

  • Thread starter Thread starter Micki
  • Start date Start date
M

Micki

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

Try this

=eomonth(G11+14,0)

Note that if 14 days is after the end of the current month this gives the
end date of the next month.

If you get a #NAME error then

Tools|Addins and check the analysis toolpak

Mike
 
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.
Click to expand...

Hi Micki,

I think the next formula will give you the result needed. D13 is the
cell with the original date.

=EOMONTH(D13+14;0)

Good luck.
Tom
 
Back
Top