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.

2 total posts (Page 1 of 1)  
| 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

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums