ExcelBanter - I need a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I need a formula (https://www.excelbanter.com/excel-worksheet-functions/64924-i-need-formula.html)

Jim

I need a formula

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

Elkar

I need a formula

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.

All times are GMT +1. The time now is 04:20 PM.