Software

Ask something
Question Locked

Excel Formulas

0 helpful
2 replies

by candace.stevens1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need to create a spreadsheet to track employee vacation eligibility. How would I go about creating that? I am completely clueless to Excel. I have the employee name, start date. Can I create another column for Vacation time that automatically calculates the number of weeks they get just from using their start date?

2 replies

by unhappyuser

Use a sum feature but be sure the formating is correct for the cells. Format the B range for Date. Format the C range for a number. User something like this for the C range:

=SUM(NOW()-B2)/100

where 100 is a vacation day for every 100 days.

EMD

This discussion is closed to new replies.