thescream80
Board Regular
- Joined
- Mar 28, 2014
- Messages
- 119
- Office Version
- 2019
- 2016
- Platform
- MacOS
What I am trying to achieve is to have a formula that I will apply to every month and for it to count the days in that month in real time yet cap the number at the end of the month.
For example using today Feb 16th
January formula = 31
February = 16 (tomorrow 17)
When the date is March 1st though Feb=28 and March =1
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
So the question is how can I have it stop counting the days after the month ends?
For example using today Feb 16th
January formula = 31
February = 16 (tomorrow 17)
When the date is March 1st though Feb=28 and March =1
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
So the question is how can I have it stop counting the days after the month ends?