Calculate Working Days Between Two Dates

[Excellerator365]

Hi,

For payroll purposes I need to be able to calculate the amount of days between two dates, but within a given payroll period.
Any help is greatly apprechiated.

 

[Excellerator365]

Here you go

 

[herofox]

hello .. You can Use This,BUT I Want From You To Change Forum Title to
Calculate Working Days Between Two Dates

=DATEDIF($B7,$C7,"D")-DATEDIF(E$2,E$3,"D")

 

[Excellerator365]

Hi, Thank you.

This however suggests that in the period 1-31 january, the gentleman has worked for 60+ days.
The maximum number of days is 31 for january.

 

[p45cal]

E7:

=MAX(0,MIN(E$3,$C7)-MAX($B7,E$2)+1)

copied down and across, will give you the count of days between two dates as you asked.
You can have working days count if you want; this assuming Sat and Sun are weekends:

=MAX(0,NETWORKDAYS.INTL(MAX($B7,E$2),MIN(E$3,$C7)))

NETWORKDAYS.INTL can also include a list of holiday dates to exclude and can define any combination of days of the week that are to be counted as working days.