Super Tough Formula Needed

[thescream80]

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?

 

[Fluff]

Duplicate to: Calculate date Formula

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.