Forum Discussion
Calculate Bed Nights
CHileman Perhaps you can work with the solution used in the attached file. It works with MAX and MIN to allow for start and end dates carrying over month-ends. and I've used three named ranges (start, middle and end) so that the formulae are easier to maintain. And I chose to not use "HERE". In stead I left the DateOut blank.
Riny_van_Eekelen Thank you so much! This is definitely a different way to approach this - I'll have to dig a little deeper into MAX and MIN functions as they are new to me. But within this system I still encounter the problem of patients who admit after the reporting period as showing negative numbers. But I suppose I can put in another IF function ahead of the formula you use to test whether or not the DATEIN > End of Month, or 15th, depending on which period I'm getting results for. But I think that should work. Thank you again!!!!
