Adding value (5,2,1 year) to a cell value based on another cell value (DOB)
I have multiple excell worksheets with list of columns. Column C is Birth Year,column D is date of Approved, I want in Column C to calculate based on this criteria:
If Column C is <35 years add 5 years to Column D
If Column C is 35-45 years add 2 years to Column D
If Column C is >45 years add 1 years to Column D.
Please See my attached file!!
I used IF funciton but the outcome is not what i want
it only take the first criteria which is TODAY()-C2>45,DATE(YEAR(D2)+1, it won't consider the entire formula? I appreciate greatly for the help.
|Training Roster.xlsx||12.69 KB|