Subtracting the date of admission to the current date
Closed
aandal
Mazzaropi
- Posts
- 1
- Registration date
- Tuesday February 7, 2017
- Status
- Member
- Last seen
- February 7, 2017
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Subtracting the date of admission to the current date
- My current location postal address - Guide
- What is the most current adobe flash player version - Download
- Mac current ip address - Guide
- Activeworkbook.worksheets current worksheet ✓ - Forum - Excel
- Current ip address of my phone - Guide
2 replies
Mazzaropi
Feb 7, 2017 at 09:16 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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
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
Feb 7, 2017 at 10:55 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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.
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.
Feb 7, 2017 at 10:34 AM
is there any other formula?