Hi Hemesh, Thanks for the help on this one. I wanted to add one more condition that needs to be checked where the person should not be on leave on the said date of the training. I'm thinking another sheet which lists the leave dates of the person. Is this doable? I'll post a revised file by tomorrow. Thank you again for your help.
Training Tracker Test 2.xlsx
I think I broke the formula. I tried to expand it to also try to incorporate leave dates but I broke it. Please can you fix it? Thanks a ton!
I will be updating this in couple of hours!
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks