View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ardus Petus
 
Posts: n/a
Default 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.