Forum Discussion
DeannaG45
Dec 17, 2022Copper Contributor
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...
PeterBartholomew1
Dec 18, 2022Silver Contributor
A slightly different interpretation of your requirement
= DATEDIF(dob, today, LEFT(setting,1))