days worked each month based on start and end date of employment

[sweenyk]

Hi, This is my first post, so hello to all.
Please see image attached - i'm trying to write a formula that would calculate the working days (networkdays is OK, with no holidays), each month per employee - based on their start, and end date of employment (if applicable) which is in column B & C.
Any help would be much appreciated.
thank you

 

[jdellasala]

How about this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		Year:	2022
2	Name	Start	End	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
3	Kody Donoso	04/04/2022
4	Raul Shrewsbury	02/02/2022	09/26/2022									169
5	Colten Davidson	05/01/2019	03/31/2022			762
6	Travis Parker	08/01/2020	12/07/2022												613
Sheet1

Cell Formulas
Range	Formula
D2:O2	D2	=DATE($C$1,COLUMN()-3,1)
D3:O6	D3	=IF( AND( NOT(ISBLANK($B3)), NOT(ISBLANK($C3)), $C3<=EOMONTH(D$2,0), MONTH($C3)=MONTH(D$2)), NETWORKDAYS.INTL($B3,$C3,1),"")
C6	C6	=TODAY()

This will only work for a year, so I added the Year: so that it can be adapted for next year which is only 24 days away! It will change automatically on Jan 1, but can be hard coded as well.
This was easy enough to set up manually, but PLEASE use XL2BB in the future.