thescream80
Board Regular
- Joined
- Mar 28, 2014
- Messages
- 119
- Office Version
- 2019
- 2016
- Platform
- MacOS
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
Thank you for any help
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
Last edited: