LinkBack URL
About LinkBacks
Rumpus24 
Try this:
in B3: =DATEDIF(A3,TODAY(),"Y")
in C3: =LOOKUP(B3,{0,1,2,3,5},{"< 1 Year","1-2 Years","2-3 Years","3-5 Years","> 5 Years"})
Try this:
in B3: =DATEDIF(A3,TODAY(),"Y")
in C3: =LOOKUP(B3,{0,1,2,3,5},{"< 1 Year","1-2 Years","2-3 Years","3-5 Years","> 5 Years"})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks