I am trying to work out how to get excel to count number of days holiday that have been earned
I need to add 0.5 per 5 days from the first of April up until today's date, but then take off the weekends
So
Cell d1 what add this up
Cell b12 would show the date 1 April Monday
Cell f12 would show the date 5 April Friday
If we say today's date is the 6 April
Cell d1 would show 0.5 and then stop counting due to the weekend and then start again on the Monday
Bookmarks