Objective: create a date counter to add 1 day to previous cell and return day of month (number 1 to 31). I also need to be able to reference every cells’ date (where the day’s number is listed) for other formulas, so it must contain the correct date. 

I have tried a few things but come up with issues:

formatting cells does not have a “D” option

a regular number counter will not know when to start at “1” for a new month

the DATE() and EOMONTH() functions are not really suitable, etc.

The one I have most success with is the TEXT() function, but notice that it does not recognize or change the month if only day is returned (it automatically thinks Jan as the month).

e.g. :

C4 = June 26th, 2024

=TEXT(C4, “mmmm d”)    output: June 26        date noted: June 26

=TEXT(C4,”d”)                   output: 26                date noted: January 26    <— this is the issue

Any help??

​Objective: create a date counter to add 1 day to previous cell and return day of month (number 1 to 31). I also need to be able to reference every cells’ date (where the day’s number is listed) for other formulas, so it must contain the correct date.  I have tried a few things but come up with issues:formatting cells does not have a “D” optiona regular number counter will not know when to start at “1” for a new monththe DATE() and EOMONTH() functions are not really suitable, etc. The one I have most success with is the TEXT() function, but notice that it does not recognize or change the month if only day is returned (it automatically thinks Jan as the month). e.g. :C4 = June 26th, 2024=TEXT(C4, “mmmm d”)    output: June 26        date noted: June 26=TEXT(C4,”d”)                   output: 26                date noted: January 26    <— this is the issue Any help??   Read More

​