Calculate days between 2 dates, based on number of days per month

[ldoodle]

Hi,

The simpler form of this is simple . I have a start and end date:

A1 = 1 Jan 2020
A2 = 1 Jul 2020 (for example, could be anything up to 60 months)
A3 = NETWORKDAYS(A1,A2) = 131

However:

A4 = 4 (for example, could be anything up to 22 (working days basically))

So I need to work out how many days something happens from start date to end date, based on the number of days per month (cell A4)

Thanks

 

[jasonb75]

Maybe

=DATEDIF(A1,A2,"m")*A4

 

[ldoodle]

Thanks!

 

[Dave Patton]

Your question is not very clear.
For information on Workdays see Excel's Help.

T202006b.xlsm
	A	B	C
1	01-Jan-20
2	01-Jul-20
3	131
4	10-Jan-20	23
5
6		Workdays	Days in Month
7	31-Dec-19
8	31-Jan-20	23	31
9	29-Feb-20	20	29
10	31-Mar-20	22	31
11	30-Apr-20	22	30
12	31-May-20	21	31
13	30-Jun-20	22	30
14	01-Jul-20	1	1
15
1c

Cell Formulas
Range	Formula
A3	A3	=NETWORKDAYS(A1,A2)
B4	B4	=LOOKUP(EOMONTH(A4,0),A7:B14)
B8:B14	B8	=NETWORKDAYS(A7+1,A8)
C8:C14	C8	=A8-A7