Hello,
I have basic excel skills and need assistance with a formula(s). We have employees, with over 90 days of employment, that get 5 sick days to start with as this is a new provision. I will need a formula to auto-populate 5 days when they reach their anniversary date and/or when they reach their 90 day employment period. Any days not used in their anniversary year do not roll over to the following year.
Welcome to the forum.
In G2:
=IF(E2>TODAY(),0,5)
I am not sure why you need the anniversary calculation. Please explain its purpose.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try this in G2
=IF(OR($E2< TODAY(),DATE(YEAR($D2)+1,MONTH($D2),DAY($D2)-1)< TODAY()),5,0)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks