software

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.

(A1) 3 month :

=DATE(YEAR(A1),MONTH(A1) 3,DAY(A1))

HTH
--
AP

quot;emillerquot; gt; a écrit dans le message de
news: ...
gt;I have a date in column A. I want to set up quarterly windows using this
gt; date. What is the formula for adding 3 months to date? I can get the
gt; ending
gt; date by subtracting a day from the beginning of the next quarter 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 ScotlandReplace @mailinator.com with @tiscali.co.ukquot;emillerquot; gt; wrote in message
...
gt;I have a date in column A. I want to set up quarterly windows using this
gt; date. What is the formula for adding 3 months to date? I can get the
gt; ending
gt; date by subtracting a day from the beginning of the next quarter date.