Previous Topic Next Topic

Subtracting the date of admission to the current date

Closed
aandal Posts 1 Registration date Tuesday February 7, 2017 Status Member Last seen February 7, 2017 - Updated by Ambucias on 7/02/17 at 04:54 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 7, 2017 at 10:55 AM
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
Related:

2 responses

Answer 1 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 7, 2017 at 09:16 AM
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
0
aandal
Feb 7, 2017 at 10:34 AM
still not working....
is there any other formula?
0
Answer 2 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 7, 2017 at 10:55 AM
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.
0

Similar discussions

If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
Can't remove threat with Windows Defender
Babarali4 -
ravida_1351 -

2 responses
How to specify macro for current active sheet
seo5906 -
Dave -

18 responses
trying to have the current date go into one cell (A1)
dbmich -
dbmich -

3 responses
Formula to subtract one cell value from another.
autigers71 -
vcoolio -

1 response