J
Jim
What is the formula to divide a number in a cell by the number of
months to date in the current year?
months to date in the current year?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
=A1/MONTH(TODAY())
=A1/MONTH(TODAY())
J
Jim
That is the formula I've been using, or =A1/MONTH(NOW()), however bot
are simply carrying the number in A1 to the new cell. Any other ideas?
are simply carrying the number in A1 to the new cell. Any other ideas?
K
kcc
I think I'm missing something. It's January, so you are dividing by 1.
What are you expecting?
kcc
What are you expecting?
kcc
J
Jim
Just copying last year's sheet and want to get it to work right for the
future. Last year's had this issue.
future. Last year's had this issue.