Remove non-business days between dates
Thanks!
"Jacob Skaria" wrote:
With Start Date in A1 and End Date in B1 try the below formula in C1 which
will give you the number of days from to both inclusive (except weekends)
=(B1-WEEKDAY(B1,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY(A1,2))+MIN(5,WEEKDAY(B1,2))+1
If this post helps click Yes
---------------
Jacob Skaria
"dgold82" wrote:
My supervisor asked me to calculate how long it takes to perform certain
projects. In one column I have start date and the other is the end date.
I would like to calculate the number of days in between but take out the
non-business days (i.e. Saturday, Sunday).
Is this possible? Thanks.
|