Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I get the duration of processing from two dates?
From PR Approved date to PO creation date including the weekend?
Thanks a lot!!
Regards,
Ahyel
Use Below Function...
=NetWorkDays(StartDate, EndDate)
Or
=Interval(EndDate-StartDate,'D')
Alternatively
num(PR Approved Date) - num(PO creation date)
Try
[PO Creation] - [PR Approved]
Or like Manish said
Hi,
Networkday excludes weekends right? How to include weekends in the count?
Thank you
NetWorkdays() : Returns the number of working days (Monday-Friday).
Better to use Interval(Enddate-StartDate,'D')
use my second option.
Use the below option if you need to include weekends:
Floor(PO_Approved_Date) - Floor(PO_Created_Date)