View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Micki Micki is offline
external usenet poster
 
Posts: 38
Default Adding 2weeks and rounding up to EOM

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.