an improved one
=IF(AND(--TEXT(LEFT(A2,10),"YYYY")=2010,--TEXT(LEFT(A2,10),"m")>=7),2011,--TEXT(LEFT(A2,10),"YYYY"))
an improved one
=IF(AND(--TEXT(LEFT(A2,10),"YYYY")=2010,--TEXT(LEFT(A2,10),"m")>=7),2011,--TEXT(LEFT(A2,10),"YYYY"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks