Thread
:
Adding 2weeks and rounding up to EOM
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Micki
external usenet poster
Posts: 38
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.
Reply With Quote
Micki
View Public Profile
Find all posts by Micki