Formula Alteration Help

[hockey99]

Hey all,

I was wondering if anyone could help me with my quandary. I need to change part of a formula to adjust an average based on how many days we are into a month.

So the formula I am currently using is this: =(IF(COUNTA(I26)>0,((I26*(29/28))-I8)/I8,"")) .

The (29/28), in bold, is the part that I am trying to automatically change. The Numerator (29), is the total number of days in the month. The Denominator (28), is how many days we have revenue for (one day less than the current day of the month).

From a high level, I am determining, from this formula, the variation of revenue numbers given how many days we are into the month.

That is, we have revenue projections for the whole month. But every few days, I tally up the revenue up to the current date. I need to see how much variance there is, given the number of days we are into the month.

Thank you in advance!

[Richard Buttrey]

Hi,

For the numerator substitute
=DAY(EOMONTH(NOW(),0))

and for the denominator

=DAY(NOW()-1)

Regards

[hockey99]

Richard,

Thank you for the help. Your solution worked!

Best