(Create bar chart) Sum up day data into month (not full month)

[basyan1991]

Hi 

I have a list of employees data. They have different start date, end date and daily wages.

How can I create a bar chart with x-axis as month. but sum up the wages base on the number of days in that month?

	Start Date	End Date	Daily wage
A	15/2/2023	15/6/2023	$100
B	1/3/2023	30/4/2023	$50
C	1/5/2023	31/1/2024	$80

i.e. the figure of A should be $100 x (28-15=13 days) in February. And $100x31 in March.

I am building a rough forecast on the future number.

Glad if you can give me a hand on this. Thanks! 

[Ahmedx]

how to calculate the networkdays
https://dropmefiles.com/dqw6c
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

[Ahmedx]

Firstly, A in February has not 13 but 14 days
second, Is this what you are looking for?

[basyan1991]

Hi

thanks for your quick response. 
yes it should be 14.

how to calculate the networkdays?