Is your "months to date" referring to the current calendar year? Then this
should do it:

=A1/month(now( ))

If your "months to date" are derrived from some other method, then we'd need
to know what that is in order to provide further assistance.

HTH,
Elkar


"Jim" wrote:

I need a formula to divide # in cell by # of months to date.