Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating eligibility dates
How do I write a multiple function that will answer the question:
What is the first quarter following the employee's one-year anniversary? Quarters being: January 1, April 1, July 1, October 1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating eligibility dates
=DATE(YEAR(DoH),INT((MONTH(DoH)+2)/3)*3+1,1)
and format as mmm d -- __________________________________ HTH Bob "PH@tic" wrote in message ... How do I write a multiple function that will answer the question: What is the first quarter following the employee's one-year anniversary? Quarters being: January 1, April 1, July 1, October 1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating eligibility dates
The suggestion doesn't seem to work. I presum the DoH is Date of Hire?
I do have a column that lists the initial hire date. For one employee, the cell is D3. Can you suggest a change to the initial suggestion that would allow me to refer to a cell? Thanks. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating eligibility dates
On Jul 7, 8:50 am, PH@tic wrote:
The suggestion doesn't seem to work. I presum the DoH is Date of Hire? I do have a column that lists the initial hire date. For one employee, the cell is D3. Can you suggest a change to the initial suggestion that would allow me to refer to a cell? Thanks. You just change DoH to D3. Then the formula can be copied down the list of employees. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating eligibility dates
I ended up using what follows and it appears to work. Thanks for all the
help. Now I just need to understand WHY it works! I appreciate the resource. =IF(ISBLANK(D2),"not yet",DATE(YEAR(D2)+1,INT((MONTH(D2)+2)/3)*3+1,1)) "Spiky" wrote: On Jul 7, 8:50 am, PH@tic wrote: The suggestion doesn't seem to work. I presum the DoH is Date of Hire? I do have a column that lists the initial hire date. For one employee, the cell is D3. Can you suggest a change to the initial suggestion that would allow me to refer to a cell? Thanks. You just change DoH to D3. Then the formula can be copied down the list of employees. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Eligibility Dates | Excel Worksheet Functions | |||
Calculating dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
calculating dates | Excel Worksheet Functions | |||
calculating with dates | Excel Discussion (Misc queries) |