=IF(OR(G2=G6-3,G2=G6-2,G2=G6-1,G2=G6),"Time to update or request details",IF(OR(G2=G6+1,G2=G6+2),"ATTENTION!! Details overdue","ok"))
Thank you very much 6Sring Jazzer. That is something that will definitely be useful to me, as my new role here requires a lot of excel formula creation/manipulation.
Bookmarks