LinkBack URL
About LinkBacks
Or try this in cell E2 ...
=IF(D2="","",IF(N(D2)>C2,D2,EDATE(C2,IF(COUNTIF(D2,"*Months*"),--SUBSTITUTE(D2," Months",""),12*SUBSTITUTE(D2," Years","")))))
Copy down.
Or try this in cell E2 ...
=IF(D2="","",IF(N(D2)>C2,D2,EDATE(C2,IF(COUNTIF(D2,"*Months*"),--SUBSTITUTE(D2," Months",""),12*SUBSTITUTE(D2," Years","")))))
Copy down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks