david gabra
Member
Hi
I have spent 4 hours trying to perfect the if statement, and not sure if I succeeded + plus they are split.
A B C
User Creation Date of User Master Date of Last Logon
AABAOLA 1 March 2022 10 Feb 2021
AABASOLA 1 March 2020 10 June 2022
AABASOLA 1 March 2020 10 March 2021
I need: -
condtion 1: if the date in column B is less than year from now -THEN "IGNORE" - ELSE "REMOVE"
conditon 2: if the date in column B is more than one year BUT the date in column C is less than a year from now,
THEN "IGNORE" ELSE "REMOVE"
How can i put that 1 exce.
I have spent 4 hours trying to perfect the if statement, and not sure if I succeeded + plus they are split.
A B C
User Creation Date of User Master Date of Last Logon
AABAOLA 1 March 2022 10 Feb 2021
AABASOLA 1 March 2020 10 June 2022
AABASOLA 1 March 2020 10 March 2021
I need: -
condtion 1: if the date in column B is less than year from now -THEN "IGNORE" - ELSE "REMOVE"
conditon 2: if the date in column B is more than one year BUT the date in column C is less than a year from now,
THEN "IGNORE" ELSE "REMOVE"
How can i put that 1 exce.