Forum Discussion
Cell to calculate Age based on Text in Adjacent cell
B2 is Start Date C2 is End Date D2 is text drop down Years, Months, Days E2 I need a formula to calculate a value between Start and End Dates in years if text in D2="Years" OR in months...
DeannaG45 Use IFS() and DATEDIF() function.
=IFS(D2="Years",DATEDIF(B2,C2,"Y"),D2="Months",DATEDIF(B2,C2,"YM"),D2="Days",DATEDIF(B2,C2,"MD"))
If want to calculate fraction values-
=IFS(D2="Years",(C2-B2)/365,D2="Months",(C2-B2)/30,D2="Days",C2-B2)
