How to compute month on month calculation with the dates table separately

[vishwanathans]

Hi Everyone,

I am not sure how to even put my requirement in table, but i will give it a shot anyway.

Below is my data.

#

Name	FTE	Start date
Anandh	1	2/14/2022
Santhosh	1	3/28/2022
Karthik	1	3/21/2022
Karthik S	1	4/1/2022
Srini	1	5/2/2022
Madhu	1	5/16/2022
Rizwan	1	6/14/2022
Alan	1	7/19/2022
Surya	1	7/4/2022
Rahul	1	8/15/2022
Mani	1	8/22/2022
Taraka	1	9/12/2022
Sesha	1	9/5/2022
Thummapudi	1	10/10/2022
Alex	1	10/14/2022
Admin	1	11/1/2022
Edwin	1	11/1/2022

Below is my result.

FTEs should be arrived based on network days in a month.

#

Name	FTE	Start date	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22
Anandh	1	2/14/2022	-	0.55	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
Santhosh	1	3/28/2022	-	-	0.17	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
Karthik	1	3/21/2022	-	-	0.39	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
Karthik S	1	4/1/2022	-	-	-	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
Srini	1	5/2/2022	-	-	-	-	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
Madhu	1	5/16/2022	-	-	-	-	0.55	1.00	1.00	1.00	1.00	1.00	1.00	1.00
Rizwan	1	6/14/2022	-	-	-	-	-	0.59	1.00	1.00	1.00	1.00	1.00	1.00
Alan	1	7/19/2022	-	-	-	-	-	-	0.43	1.00	1.00	1.00	1.00	1.00
Surya	1	7/4/2022	-	-	-	-	-	-	0.95	1.00	1.00	1.00	1.00	1.00
Rahul	1	8/15/2022	-	-	-	-	-	-	-	0.57	1.00	1.00	1.00	1.00
Mani	1	8/22/2022	-	-	-	-	-	-	-	0.35	1.00	1.00	1.00	1.00
Taraka	1	9/12/2022	-	-	-	-	-	-	-	-	0.68	1.00	1.00	1.00
Sesha	1	9/5/2022	-	-	-	-	-	-	-	-	0.91	1.00	1.00	1.00
Thummapudi	1	10/10/2022	-	-	-	-	-	-	-	-	-	0.61	0.80	0.80
Alex	1	10/14/2022	-	-	-	-	-	-	-	-	-	0.57	1.00	1.00
Admin	1	11/1/2022	-	-	-	-	-	-	-	-	-	-	1.00	1.00
Edwin	1	11/1/2022	-	-	-	-	-	-	-	-	-	-	1.00	1.00

Can anyone help me with this.

Thanks for your help with this.

Thanks,

[Anonymous]

Hi @vishwanathans ,

I'm a little confused about your needs, Could you please explain them further? Could you tell me your calculate logic?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[vishwanathans]

Hi,

Thank for taking the efforts to look into this.

Lets take example for "Anandh" line 1.

His start date in the project was on Feb 14, 2022. Lets assume over all working days on Feb'22 is 20. So his FTE for Feb should be (Feb 14 to 28 Feb there are about  11 working days on this window baring saturday and sunday) so the calculation for Feb should be 11/20 = 0.55 FTE and for March - Dec  he would be counted as 1 full FTE based on "FTE" column in the table.

Basically i need to prorate the FTEs for the starters on the particular month, and actual FTE for rest of the Year.

Does that make sense?

Thanks,