lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have the table below and I want to find the day different between today - DoB. So I used Days()
I highlighted cells C2:C12 and then typed this formula in C2
C2=DAYS(B2:B20-A2:A20)
Then tried to press CTRL+SHIFT+Enter
or Ctrl +Enter
or Enter
all did not work, I am using 365. So I thought excel 365 you do not need array formula anymore. But I also tried to do that formula as an array but it did not work. How can I do that as one shot? I can do Days(B2-A2) and then use auto fill but I thought I can do array formula as well. Thank you very much.
I have the table below and I want to find the day different between today - DoB. So I used Days()
I highlighted cells C2:C12 and then typed this formula in C2
C2=DAYS(B2:B20-A2:A20)
Then tried to press CTRL+SHIFT+Enter
or Ctrl +Enter
or Enter
all did not work, I am using 365. So I thought excel 365 you do not need array formula anymore. But I also tried to do that formula as an array but it did not work. How can I do that as one shot? I can do Days(B2-A2) and then use auto fill but I thought I can do array formula as well. Thank you very much.
dob | today |
10/18/00 | 2/06/20 |
7/29/14 | 2/06/20 |
10/09/00 | 2/06/20 |
11/24/94 | 2/06/20 |
2/13/06 | 2/06/20 |
10/06/09 | 2/06/20 |
7/16/17 | 2/06/20 |
7/03/11 | 2/06/20 |
8/01/11 | 2/06/20 |
6/06/10 | 2/06/20 |
12/20/95 | 2/06/20 |