Thread
:
I want to set up quarterly windows based on a date
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Ardus Petus
Posts: n/a
I want to set up quarterly windows based on a date
(A1) + 3 month :
=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
HTH
--
AP
"emiller" a écrit dans le message de
news:
...
I have a date in column A. I want to set up quarterly windows using this
date. What is the formula for adding 3 months to date? I can get the
ending
date by subtracting a day from the beginning of the next quarter date.
Reply With Quote