Calculate date Formula

[thescream80]

I am trying to calculate number of days per month without having to change the date every day and it to only calculate to the days within THAT month.

A1 =TODAY()
A2 =2/1/22

To get today's date updated automatically i am using this formula =TODAY()
To get current day count from the beginning of the month I subtract =A1-A2

Is that a way to Max A1 so it does not count the days past 2/28, or 3/31 ect

=TODAY()	Number of Days of Current month
=2/1/22	=A1-A2
	Need the above to not count the days after the end of the month

Thank you for any help

 

[thescream80]

Does #4 work? If not, what results should be?

#4 Does work

Only thing trying ot figure out is how to use this to use this to work with a Year as well

2022 - 47 (as of feb 16th)
2023 - 0
2024 - 0

Any help on that?

 

[thescream80]

Here's one way you could do it (there are probably several others)

	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2		Jan 22	Feb 22	Mar 22	Apr 22	May 22	Jun 22	Jul 22	Aug 22	Sep 22	Oct 22	Nov 22	Dec 22
3		31	17	0	0	0	0	0	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
B2:M2	B2	=EDATE(DATE(YEAR(TODAY()),1,1),COLUMNS($B2:B2)-1)
B3:M3	B3	=MAX(0,1+MIN(TODAY(),EOMONTH(B2,0))-B2)

#4 Does work
Only thing trying ot figure out is how to use this to use this to work with a Year as well
2022 - 47 (as of feb 16th)
2023 - 0
2024 - 0
Any help on that?

 

[bebo021999]

With to day is 17-Feb
A1 could be: 2022 (if <20000 (equals 3-Oct-1954, to define it's year number)) , or real date
B1:

=IF(A1<20000,TODAY()-DATE(A1,1,1)+1,DAY(MIN(EOMONTH(A1,0),TODAY())))