Sum of year to date

[juanitadeb]

Beginning of month

01/01/2022​

01/02/2022​

01/03/2022​

01/04/2022​

01/05/2022​

01/06/2022​

01/07/2022​

01/08/2022​

01/09/2022​

01/10/2022​

01/11/2022​

01/12/2022​

Net working days

21​

20​

23​

21​

22​

22​

21​

23​

22​

21​

22​

22​

This part data and I have a separate sheet where I am gathering data for each month, for example, May 2022.

Now I want to sum the net working days from year to date - from 01/01/2022 till May 2022 for example.

But the month May is not fixed so I need a formula that sums the cells from 01/01/2022 till the cell the month is in. (could be any month)

Also, the beginning date is always the start of the year which is why it is from year to date.

 

[ExceLoki]

with this possible solution you can select your dates from the drop down, and then it will sum the numbers through that month.
hope this helps with what you're going for. I also added a cell that figures year to date based on today()
-------------

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Beginning of month	1/1/2022	2/1/2022	3/1/2022	4/1/2022	5/1/2022	6/1/2022	7/1/2022	8/1/2022	9/1/2022	10/1/2022	11/1/2022	12/1/2022
2	Net working days	21	20	23	20	22	22	21	23	21	21	22	22
3
4		start	end	total days	year to date
5	sum dates	1/1/2022	8/1/2022	172	236
Sheet1

Cell Formulas
Range	Formula
D5	D5	=SUMIFS(B2:M2,B1:M1,(">="&B5),B1:M1,("<="&C5))
E5	E5	=SUMIFS(B2:M2,B1:M1,(">="&B1),B1:M1,("<="&TODAY()))

Cells with Data Validation
Cell	Allow	Criteria
B5:C5	List	=$B$1:$M$1

 

[juanitadeb]

Sorry for the late reply! This worked perfectly thank you for your help

 

[ExceLoki]

happy to help. thanks for the feedback