Dated if excluding weekends

[Anya333]

Hi, can anyone help me with this formula please?
Row 8 - I want to calculate number of days per month based on start date (B1) and end date (B2) but excluding weekends. Please help. Many thanks.

 

[DHP]

Did you try Networkdays function?

 

[Anya333]

I tried this Networkdays formula but I got 53 days for July which is incorrect

 

[DHP]

From 20.July to 30.Sept = 53 working day, the formula ok.
Seem as you want to colculate in july only, you can add date(yyyy,mm,dd) like this:
NETWORKDAYS(A7,IF(A8<=DATE(2022,7,31),A8,DATE(2022,7,31)))

 

[Phuoc]

Try this in B8:

=NETWORKDAYS(MAX($B$1,B4),MIN($B$2,B5))

 

[FormR]

Or this slight amendment to post#5..

=MAX(NETWORKDAYS(MAX($B1,B4),MIN($B2,B5)),0)

 

[Anya333]

Try this in B8:

=NETWORKDAYS(MAX($B$1,B4),MIN($B$2,B5))

yay it's worked. Thank you so much

 

[Anya333]

sorry for another question - can I use the same Max/Min formula for calendar days ie. MAX(DAYS(MAX($B1,B4),MIN($B2,B5)),0) for cell B7 instead of using Datedif?

 

[Phuoc]

In B7:

=MAX(MIN($B$2,B5)-MAX($B$1,B4)+1,0)

 

[Anya333]

In B7:

=MAX(MIN($B$2,B5)-MAX($B$1,B4)+1,0)

Thanks again