sksanjeev786
Well-known Member
- Joined
- Aug 5, 2020
- Messages
- 882
- Office Version
- 365
- 2016
- Platform
- Windows
Hi Team,
I need difference between 2 dates like D2 - D3 =2 month and XXX days.
I need difference between 2 dates like D2 - D3 =2 month and XXX days.
book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | S.No | Date of Joining | Different | ||||||
2 | 1 | 5/1/2006 | 14 years 11 months 12 Days | ||||||
3 | 2 | 6/26/2006 | 14 years 9 months 18 Days | ||||||
4 | 3 | 3/19/2007 | 14 years 0 months 25 Days | ||||||
5 | 4 | 5/11/2007 | 13 years 11 months 2 Days | ||||||
6 | |||||||||
7 | |||||||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A3:A5 | A3 | =A2+1 |
D2:D5 | D2 | =DATEDIF(B2,TODAY(),"y")&" years "&DATEDIF(B2,TODAY(),"ym")&" months "&DATEDIF(B2,TODAY(),"md")&" Days " |