Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Using the admission date in a spreadsheet, I have added a column that counts
the number of days a patient is on service [=today()-B2+1]. Information regarding the patient stays on the spreadsheet for several days, even if the patient is discharged. I would like to know if it is possible to add to the formula, or create another that would stop counting if there is a date entered in the discharge column. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I create a if-then formula? | Excel Worksheet Functions | |||
how do I create a if-then formula? | Excel Worksheet Functions | |||
How to create specific formula | Excel Worksheet Functions | |||
How do I create a formula that would allow me to subtract from a d | New Users to Excel | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions |