"IF" Formula

J

Jenn

I am trying to track accrued personal days within our physical year of July 1 - June 30. 1 day is earned with every 4 months of employment for a max of 3 days per physical year, unless hired mid year - then it would be from that date of hire.

I also need a formula (if possible) to subtract the earned days if not used within 1 year of receiving them

Can someone help me ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Month days over a time period 5
Need Formula for Calculating Accrued Vacation Time 2
Date formula rounded up 2
Date formula 3
Calculating 0
IF-AND-OR? 5
Excel Formula for years and months 2
Percentage of month passed formula 1

Top