Divide by the number of days that have gone in the month

[Legacy 116183]

How do I do it?

I wish to divide cell m31 by the number of days which have elapsed in the month. Today it will be 10, tomorrow 11, etc.

Is this possible or o I need to create two cells with today() and the end of the month and create a third with the difference using dividing m16 by that cell?

Thanks

 

[arthurbr]

Simply use =day(today())

 

[HappierThan]

Put in say X1=TODAY() and in Y1=DAY(X1) You can use /$Y$1 in your formulas.

 

[Legacy 116183]

Thank you both.

 

[arthurbr]

You're welcome