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.
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
"emiller" <[email protected]> a écrit dans le message de
news: [email protected]...
>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.
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
[email protected]
Replace @mailinator.com with @tiscali.co.uk
"emiller" <[email protected]> wrote in message
news:[email protected]...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks