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 total the
amount at the bottom of each department for what has been entered to date,
and then I have a daily average, then EOM Proj
--
Tasha