Start date is counted as zero day
End date should be yesterday date
Example:-
start date is (27-Nov-2025)+1
End date is today()-1
In between Sunday on 30-Nov-2025
This givs me result as 4, but actual days is 5
| Edit: Changed subject, was How to calculate days correctly between two days excluding 2nd and 4th Saturday and all sunday and excluding holidays Make your post understandable by others -- MrProgrammer, forum moderator |