Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculating per quarter
I want my spreadsheet to calculate days per quarter, as in every quarter
employees are given 'x' days of vacation time. How do I do this? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculating per quarter
Hi
If you put the number of the quarter in cell A1 (so 1, 2, 3 or 4), and the year in A2, then put in: B1: =DATE(A2,(A1-1)*3+1,1) to get the begin date of the quarter C1: =DATE(A2,A1*3,0) to get the ending date of the quarter D1: =C1-B1 to get the number of days in between -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "bklex" wrote: I want my spreadsheet to calculate days per quarter, as in every quarter employees are given 'x' days of vacation time. How do I do this? |
#3
|
|||
|
|||
Works great with the following small mod:
A1: The quarter (so 1, 2, 3 or 4), A2: The year (eg 2012), B1: =DATE(A2,(A1-1)*3+1,1) C1: =DATE(A2,A1*3+1,0) D1: =C1-B1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate a quarter | Excel Discussion (Misc queries) | |||
Calculate Quarter end? | Excel Discussion (Misc queries) | |||
Quarter End Date | Excel Worksheet Functions | |||
First and Last Day of the Quarter | Excel Worksheet Functions | |||
Calculating Interest where rate changes per quarter | Excel Discussion (Misc queries) |