Formula

[Jim]

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

[JE McGimpsey]

One way:

=A1/MONTH(TODAY())

In article <[email protected]>,
"Jim" <[email protected]> wrote:

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

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

[kcc]

I think I'm missing something. It's January, so you are dividing by 1.
What are you expecting?
kcc
"Jim" <[email protected]> wrote in message
news:[email protected]...
> 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]

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