Pace minus a day?

[Erkjerk]

The formula I have in place is =E1/DAY(TODAY())*31 for January. This works great as long as we don't close for a day in the month. Of course we were closed January 1st. How can i make my current formula not calculate jan 1st in the pace? Thanks.

 

[Erkjerk]

Won't the formula be jacked on jan 31st though if you just use 30 days

 

[footoo]

What do you mean "jacked"? Your question indicates you do not understand the formula. Why don't you test a few examples with some hard dates instead of TODAY()? Also look up the help files re DAY and TODAY.
The formula is returning today's day of the month less the number of closed days - so on Jan 31 it will return 31 less 1.

 

[footoo]

Assuming the following data :
E1 – Actual month-to-date amount as of yesterday
F1 – Actual month-to-date number of closed days as of yesterday
G1 – Total number of closed days for the whole month

The formula to return the expected amount for the whole month :
=E1/DAY(TODAY()-1-F1)*(DAY(EOMONTH(TODAY()-1,0)-G1))