Hi
Im trying to find out if there is a way to work out on excel if a specific date is covered if I only have the from and to dates?
Specifically this relates to Sickness Absence and I want to see how many people were sick on Christmas day without just using the normal filters.
What I am looking for is something similar to this:
untitled.JPG
Thanks
Please try this file.
Please click 'Add reputation', if my answer helped you.
ramananhrm With your permission Slight Modification in your suggested formula. This will work without any Year Issue...
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below 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