Hi all,
I'm trying to create a formula that will achieve the following:
- Sum up the total # of days that fall between two dates within the last previous month
- Date 1: Admit date
- Date 2: Discharge date
For example, Patient A was admitted on 6/1/24, and discharged on 7/15/24. I'd like to know how many of those patient days fell into the previous month (Today's month - 1, so July).
I also have a field calculating the total # of days between those dates, but not sure that's helpful.
Another example:
Patient B was admitted on 2/14/24 and discharged on 8/5/24. How many days did the patient spend in the hospital last month?
This is for invoicing purposes, so we're trying to assume that invoices for each month are sent out after the month in which they were incurred.
Appreciate your assistance- don't even know where to start here!
