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
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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
still not working....
is there any other formula?
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!