Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I want to set up quarterly windows based on a 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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation based on date | Excel Discussion (Misc queries) | |||
Calculate Start Dates based on Need-By Date? | Excel Worksheet Functions | |||
change date based on time | Excel Discussion (Misc queries) | |||
Counting unique records based on date range | Excel Worksheet Functions | |||
LINK ONE ROW BASED ON CONTENTS OF A COLUMN WITHIN THE ROW (DATE) | Excel Worksheet Functions |