Related:
- Subtracting the date of admission to the current date
- Gmail current account ✓ - Forum - Gmail
- Key allows the user to save current document - How-To - Keyboard
- Find current location by phone number - How-To - Mobile
- Excel macro current sheet ✓ - Forum - Excel
- Excel - enter current time in a cell by clicking it ✓ - Forum - Office Software
2 replies
Mazzaropi
- Posts
- 1852
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- November 7, 2020
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
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
- Posts
- 1852
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- November 7, 2020
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.
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!
is there any other formula?