subtracting the date of admission to the current dateClosed

Question

GOod am, i just want to ask how will i create a formula as follows on the same excel,
 1. subtracting the date of admission to the current date 
 2. if discharge date is available discard the first formula then kindly subtract the discharge from the admission date 
my end results shoud be in Days.

THank you

Mazzaropi · Answer

aandal, Good morning.
Suppose:
A1 --> Admission Date
B1 --> Discharge date
Try to use:
C1 --> =IF(B1<>"", B1-A1, TODAY()-A1)
Is that what you want?
I hope it helps.
 --
Belo Horizonte, Brasil.
Marcílio Lobão

Mazzaropi · Answer

aandal, 
The formula works as requested.
Please tell us what kind of errors appear.
Show us the layout of your spreadsheet.
Do the cells contain actual dates or texts?
If you prefer, save your spreadsheet to a free website, www.speedyshare.com, and place the download link here.
I'm sure the answer will appear quickly to you.

Subtracting the date of admission to the current date

2 replies

Subscribe To Our Newsletter!