Networkdays formula between today and go live date

Karl86

Hi, I would like a formula to calculate the number of network days between todays date and a go live date and return a negative if go live is in past and positive if go live is in future

eg todays date 24/03/25, (go live date) 29/03/25 = 5 days

Here is the formula im currently using

=TODAY() - [Requested Go-Live]@row

on my formula its showing -5 but would like this to just be 5 days and only show negative for dates in the past.

Thanks

Adam Murphy

Have you tried =NETWORKDAYS(TODAY(), [Requested Go-Live]@row) ? That should work. Hope this helps!

Adam Murphy

Have you tried =NETWORKDAYS(TODAY(), [Requested Go-Live]@row) ? That should work. Hope this helps!

Karl86

this worked thank you @Adam Murphy