Previous Topic Next Topic

Subtracting the date of admission to the current date

[Closed]
Report
Posts
1
Registration date
Tuesday February 7, 2017
Status
Member
Last seen
February 7, 2017
 -
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
 -
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

2 replies

Answer 1 / 2
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
 145
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
Report

still not working....
is there any other formula?
Answer 2 / 2
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
 145
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.
Ask a question