How to get the processed days from 2 dates?

[#1]

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

[MK_QSL]

Use Below Function...
=NetWorkDays(StartDate, EndDate)

Or

=Interval(EndDate-StartDate,'D')

[marcus_malinow]

Alternatively

num(PR Approved Date) - num(PO creation date)

[rustyfishbones]

Try

[PO Creation] - [PR Approved]

[rustyfishbones]

Or like Manish said

[#6]

Hi,

Networkday excludes weekends right? How to include weekends in the count?

Thank you

[manojkulkarni]

NetWorkdays() : Returns the number of working days (Monday-Friday).

Better to use Interval(Enddate-StartDate,'D')

[MK_QSL]

use my second option.

[#9]

Use the below option if you need to include weekends:

Floor(PO_Approved_Date) - Floor(PO_Created_Date)