Workday Formulas

[cyberice]

Hi there,
I am working on a gantt and I am struggling just to count the work days, In the attached I only need to return 20 days not 29?
Any ideas?
Regards

[nick.williams]

Use NETWORKDAYS.INTL to count the number of workdays instead of subtracting the start date from the end date.

The format is NETWORKDAYS.INTL(start_date,end_date,[weekend],[holidays])

For [weekend] you probably want to use 1 which counts saturday and sunday as weekends

For [holidays] you should have a range somewhere which contains the holiday dates.

[cyberice]

Use NETWORKDAYS.INTL to count the number of workdays instead of subtracting the start date from the end date.

The format is NETWORKDAYS.INTL(start_date,end_date,[weekend],[holidays])

For [weekend] you probably want to use 1 which counts saturday and sunday as weekends

For [holidays] you should have a range somewhere which contains the holiday dates.

Hi there

Thanks for the quick response, having trouble with my colour coded if I select another colour, it returns false not 0

[nick.williams]

Try this in J15:

=IF(ISBLANK($E15),0,IF($F15=J$14,NETWORKDAYS.INTL($D15,$E15,1,DATE(2022,1,3)),0))

Copied to other cells should work fine?

NB you will want to change DATE(2022,1,3) to a range of cells with your holiday dates in.

[cyberice]

Prefect thank you and enjoy your weekend