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

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top