I have been struggling to replicate the network day formula (excel) in easy morph. Has anyone does this? Will appreciate help.
NETWORKDAYS(H3,A3)
H column = Opened date
A column = Reporting date
I have been struggling to replicate the network day formula (excel) in easy morph. Has anyone does this? Will appreciate help.
NETWORKDAYS(H3,A3)
H column = Opened date
A column = Reporting date
Here is my solution:
Assuming that [DateA]
comes before [DateB]
this expression calculates the net number of workdays between [DateA]
(inclusive) and [DateB]
(inclusive):
min([DateB], weekstart([DateB]-1)+5) - max([DateA], weekstart([DateA]+1)+1) - ((weekstart([DateB]-1)-weekstart([DateA]+1))/7) * 2 + 1
Some tests and comparison with Excel:
networkdays.morph (8.7 KB)
Dates.xlsx (18.0 KB)
Thank you so much . You are a rockstar
You’re welcome!
To make things simpler we’ve added two new functions to EasyMorph:
Both functions available in the updated version which can be downloaded from our web-site: https://easymorph.com/download.html
Amazing - Thank you