| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calc Date Based on Year
I need a formula that calculates the end date of each calendar quater based
on the year. For example, if the year in A1 = 2009 then the dates in A2 through A5 should be 1/31/09, 4/30/09, 7/31/09 & 10/31/09 respectively. When I change A1 to 2010, I need the dates to reflect 2010 dates. I would also need the formulat to account for leap years if possible. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calc Date Based on Year
In A2 thru A5:
=DATE(A1,1,31) =DATE(A1,4,30) =DATE(A1,7,31) =DATE(A1,10,31) -- Gary''s Student - gsnu200901 "Johnny" wrote: I need a formula that calculates the end date of each calendar quater based on the year. For example, if the year in A1 = 2009 then the dates in A2 through A5 should be 1/31/09, 4/30/09, 7/31/09 & 10/31/09 respectively. When I change A1 to 2010, I need the dates to reflect 2010 dates. I would also need the formulat to account for leap years if possible. Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calc Date Based on Year
Use
=DATE(2009,ROW(A1)*3+1,0) and copy down 4 cells -- __________________________________ HTH Bob "Johnny" wrote in message ... I need a formula that calculates the end date of each calendar quater based on the year. For example, if the year in A1 = 2009 then the dates in A2 through A5 should be 1/31/09, 4/30/09, 7/31/09 & 10/31/09 respectively. When I change A1 to 2010, I need the dates to reflect 2010 dates. I would also need the formulat to account for leap years if possible. Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calc Date Based on Year
Thank you. Just what I needed. I'll make sure to post feedback.
"Gary''s Student" wrote: In A2 thru A5: =DATE(A1,1,31) =DATE(A1,4,30) =DATE(A1,7,31) =DATE(A1,10,31) -- Gary''s Student - gsnu200901 "Johnny" wrote: I need a formula that calculates the end date of each calendar quater based on the year. For example, if the year in A1 = 2009 then the dates in A2 through A5 should be 1/31/09, 4/30/09, 7/31/09 & 10/31/09 respectively. When I change A1 to 2010, I need the dates to reflect 2010 dates. I would also need the formulat to account for leap years if possible. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with pulling data based on latest date for a year | Excel Discussion (Misc queries) | |||
| Year-to-date based on current month | Excel Discussion (Misc queries) | |||
| Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) | Excel Discussion (Misc queries) | |||
| Calculate a date based on period and year | Excel Worksheet Functions | |||
| How do I change date based on year | Excel Worksheet Functions | |||
Linear Mode
