Question

Locked

Excel Formulas

By candace.stevens1 ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Yes

by unhappyuser In reply to Excel Formulas

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

Related Discussions

Related Forums