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
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 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

Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
142
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
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
142
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!