I would like to write a formula in a column that says:
IF(Open_Date, between 2021-01-01 and 2020-07-31 then 0%,
IF(Open_Date, between 2022-08-01 and 2022-12-31 then 2% * 1,IF(Open_Date, between 2023-01-01 and 2023-31-12 then 3% * 1
Would anyone be able to assist me please?Thanks,D
Go to Solution.
@Kryssy I would try something like this:
[Open_Date] >= DATE(2020,7,31) && [Open Date] <= DATE(2021,1,1),0,
[Open_Date] >= DATE(2022,8,1) && [Open Date] <= DATE(2022,12,31),.02*1,
[Open_Date] >= DATE(2023,1,1) && [Open Date] <= DATE(2023,12,31),.03*1
View solution in original post
@Greg_Deckler THANK YOU!!!!
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!