"sueshe" wrote:
I am trying to set up a formula in an Excel spreadsheet to calculate
daily, the end of month projection for total patient visits. I enter manually
a daily amount, and have the formula currently set up to take the daily
average times the number of days in the month and subtract the month
to date days to get the EOM Projection. This seems to work on most
of my departments, however some of them are showing up with a lesser
amount for the EOM Proj than what is currently already totalled for Month
To Date. I can't seem to find out why??? Any suggestions, or maybe a
better formula?

I suggest that you post the formula(s) that you are currently using.
What you describe is the correct algorithm. But the devil is in the
details.

One possible mistake might be in determining the number of days in the
month. That is, perhaps you are using to high a number.

Another possible mistake might be that you compute the daily average as
an integer (INT, ROUND or ROUNDDOWN). If that is rounded down from the
exact average, then you will undershoot the monthly estimate when you
multiply by the number of days.