Thread
:
How do I select same day of month, 3 mths apart when day 31 of mth
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave O
Posts: n/a
How do I select same day of month, 3 mths apart when day 31 of mth
Please try this one out, with the start date in A1. Does it
accommodate mid-month start dates properly?
=EOMONTH(A1,3)-(DAY(EOMONTH(A1,0))-DAY(A1))
Reply With Quote