Thanks for sharing
Here is a formula to calculate the number of weekdays between two dates, inclusive. That is, the number of weekdays between Monday and the next day are 2. I am using this for a schedule spreadsheet where I need to see working days.
In this example, cell A2 contains the earlier date and B2 contains the later date.
If you don't want it to be inclusive you can remove "+1".
This, of course, does not take holidays into account.
Formula doesn't work, though
A2 = Friday 11th May 2007
B2 = Tuesday 15th May 2007
formula gives a result of 1
For a count of weekdays between two dates without using NETWORKDAYS
I found some time after posting that this didn't work. I developed a formula that does work, though it's rather complex. If anybody really wants to see it I'll pull it out of the junk drawer.
Then I discovered the NETWORKDAYS function and figured there was no point in continuing to post updates to this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)