Formula

Thread view:

Thread rating:

Jim - 12 Jan 2006 23:38 GMT

What is the formula to divide a number in a cell by the number of
months to date in the current year?

JE McGimpsey - 12 Jan 2006 23:49 GMT

One way:

=A1/MONTH(TODAY())

> What is the formula to divide a number in a cell by the number of
> months to date in the current year?

Jim - 13 Jan 2006 00:01 GMT

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?

kcc - 13 Jan 2006 02:08 GMT

I think I'm missing something. It's January, so you are dividing by 1.
What are you expecting?
kcc

> 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?

Jim - 13 Jan 2006 02:29 GMT

Just copying last year's sheet and want to get it to work right for the
future. Last year's had this issue.