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
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