I don't need the actual value but what is shown
 

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

I don't need the actual value but what is shown
 

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

I don't need the actual value but what is shown
 

=F10/MONTH(TODAY())
Regards,
Stefi

€žBenny€� ezt Ã*rta:

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