Date Formula counting days Closed

Question

Hello, 
If anyone could help me, I would greatly appreciate it, I need help with counting days if there is not an end date on the report. 
Ex: Count the days from the admission date to the end of the month I am doing the report if there is no admit date. If there is an admit and discharge date would I just use the DAYS360 formula? 
My work wants to know what amount of days a patient was at our hospital from admit date to discharge date but some patients haven't discharged yet so I would want to count the days from admit to the end of the month that I am doing the report.   Thanks so much, Greatly appreciate for all ideas. 


System Configuration: Windows / Internet Explorer 11.0

ac3mark · Answer

So, it should calculate daily, or only when you want it to?

Brande74 · Answer

At the end of every month would be great.

ac3mark · Answer

So it is to figure what day it is, and only act when it finds out is the last day of the month? 
 

Have you turned on the developer tab in Excel yet?

TrowaD · Answer

Hey Mark, what happened to KISS?

When the admit date is in A1 and the discharge date is in B1:
=IF(B1="",DATE(YEAR(A1),MONTH(A1)+1,0)-A1,B1-A1)

Best regards,
Trowa

Brande74 · Answer

What if there is no discharge date and I want to count from the admission date to the end of the month.

Date Formula counting days

5 responses

Similar discussions

Subscribe To Our Newsletter!