LinkBack URL
About LinkBacks
I am using datediff to determine the number of days between two dates but then I would like to discount all the Sundays. There are lots of examples excluding weekends but I just want to exclude Sundays only for an array I will be using.
I am using datediff to determine the number of days between two dates but then I would like to discount all the Sundays. There are lots of examples excluding weekends but I just want to exclude Sundays only for an array I will be using.
Try this ...
=NETWORKDAYS.INTL(A1,B1,11)
Hi,
One way
Formula:
Please Login or Register to view this content.
Where A1 is the 1st date and A2 the second. Add a +1 if you want the inclusive number of days
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks