how do I create or add to a formula . . .

[Steph]

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.

 

[Bob Phillips]

=IF(C2<>"",C2-B2-1,TODAY()-B2-1)

 

[Steph]

Thanks, Bob. The only change I had to make was a +1 instead of a -1, as we
need to count the day of admission as 1 full day.
Steph

=IF(C2<>"",C2-B2-1,TODAY()-B2-1)

--
HTH

Bob Phillips

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.

 

[Bob Phillips]

Doh! You actually said that in your original post.

Bob

Thanks, Bob. The only change I had to make was a +1 instead of a -1, as we
need to count the day of admission as 1 full day.
Steph

=IF(C2<>"",C2-B2-1,TODAY()-B2-1)

--
HTH

Bob Phillips

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.