Excel Forum
Similar Content
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Get Day Name from a Date in Excel
Tutorial: How to get the name of a day from a date in Excel. This returns, for example, "Tuesday" fo...
Get the Number of Workdays Between Two Dates in Excel
Tutorial: How to calculate the total number of working days between two dates in Excel.  This allow...

Excel Magic Trick #202: Calculate Vacation Days

Create a formula that calculates the number of vacation days an employee gets based on hire date using the functions TODAY, YEAR and IF functions.
The = TODAY () function will always put today's date in the cell
The YEAR function takes a date serial number and gives you the year.
For more about the IF function, see this IF function video series: Various Excel IF function Tricks

Got a Question? Ask it Here in the Forum.