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

[Benny]

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

 

[cm]

try month(today()) - should return 10

 

[Stefi]

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

„Benny†ezt írta: