LinkBack URL
About LinkBacks
Hi all, i'm stuck with this, it seems to be by passing the B4 May 23 bit of the formula.
=IF(R2="","No Date",IF(AND(R2>"31/01/2023",R2<"01/05/2023"),"B4 May 23",IF(AND(R2>TODAY(),R2<"31/10/2023"),"B4 Nov 23","Date Past")))
Hi all, i'm stuck with this, it seems to be by passing the B4 May 23 bit of the formula.
=IF(R2="","No Date",IF(AND(R2>"31/01/2023",R2<"01/05/2023"),"B4 May 23",IF(AND(R2>TODAY(),R2<"31/10/2023"),"B4 Nov 23","Date Past")))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks