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.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Collapse -


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:


where 100 is a vacation day for every 100 days.


Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums