Date formula

[u15986]

I have a cell that auto calculates the current date. I have another cell that I want to show how many days have passed during the current month. Ex: if today is 05 May 13 then the second cell would show the number 5. What formula would I use to make this happen automatically?

 

[Norie]

Perhaps this, where A1 is the current date.

=DAY(A1)

 

[vbaanalyst]

todays date: =today()
days so far this month =Day(today())

 

[u15986]

That did it! TY!!