Forum Discussion
Calculating Networkdays if it's blank in Power Query
Hi Everyone, I would to calculate networkdays between the [Start] and [End]. the formulla went well with Networkdays([Start],[End],Holiday) but in case [End] = null I've tried to repla...
Hi Anonymous ,
How about this:
if [End] = null then Networkdays([Start], Date.From(DateTime.LocalNow()), Holiday) else Networkdays([Start], [End], Holiday)
Let me know 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi Anonymous ,
How about this:
if [End] = null then Networkdays([Start], Date.From(DateTime.LocalNow()), Holiday) else Networkdays([Start], [End], Holiday)
Let me know 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/