mart_mrexcel
Board Regular
- Joined
- Aug 23, 2008
- Messages
- 231
I have 2 dates 10-June-19 and today's Date (eg19-Dec-20), i used the formula as: =(DATEDIF([@[Joining Date]],TODAY(),"Y")&"."&DATEDIF([@[Joining Date]],TODAY(),"ym")). My Query is:
1.) How can i have a result as 1.06 (i.e. .06 as the months), instead of 1.6
2.) If in case the decimal reaches the .12, it will add to the whole number so it will be 2
3.) if i have a total years of 1.06 and i wanted to add in 3.10, how can i have a result of 5.04 (i.e. 5yrs and 4 months)
Thanks
1.) How can i have a result as 1.06 (i.e. .06 as the months), instead of 1.6
2.) If in case the decimal reaches the .12, it will add to the whole number so it will be 2
3.) if i have a total years of 1.06 and i wanted to add in 3.10, how can i have a result of 5.04 (i.e. 5yrs and 4 months)
Thanks