Thread
:
I want to set up quarterly windows based on a date
View Single Post
#
3
Posted to microsoft.public.excel.newusers
Sandy Mann
Posts: n/a
I want to set up quarterly windows based on a date
One way that would give you the last day of the quarter:
=A1+92-DAY(A1+92)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
Replace @mailinator.com with @tiscali.co.uk
"emiller" wrote in message
...
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