Try this:

=DAY(TODAY())

"Mike" wrote:

I need a constitantly updating date function on a spreadsheet. For example,
everyday, the number I divide a certain total by depends on what day of the
month it is. Like if it is the 8th of November, my total would be divided by
8. The next day, Excel would recognize that it was 9th, and automatically
divide the number by nine. My question is what formula do I enter so my
product cell can refer to the 'day' cell to grab the number to divide by?

Any help would be great, thanks.