try month(today()) - should return 10
--
hope to help,
cm


"Benny" wrote:

Hello. I have a cell F10 that needs that needs to be divided by the current
month. Example. D10 has a value of 100 and it needs to be divided by 10
because the current month is October.

I tried to use in cell A10 Today() then format that cell to m and it shows
the number 10.

So that works fine but the result for F10 is 0 because the true value of
that cell A10 is 10/28/2009.

Thanks