example (eDIT).xlsx
for 1 year
=edate(cell's name,12)<today() -> r
=edate(cell's name,11)<=today() -> y
=edate(cell's name,9)<=today() -> o
=edate(cell's name,6)<=today() -> g
for 2 year
=edate(cell's name,24)<today() -> r
=edate(cell's name,23)<=today() -> y
=edate(cell's name,21)<=today() -> o
=edate(cell's name,18)<=today() -> g
for 3 year
=edate(cell's name,36)<today() -> r
=edate(cell's name,35)<=today() -> y
=edate(cell's name,33)<=today() -> o
=edate(cell's name,30)<=today() -> g
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks