Hello,
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
Solved! Go to Solution.
@Anonymous I would try something like this:
Column =
SWITCH(TRUE(),
[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
)
@Anonymous I would try something like this:
Column =
SWITCH(TRUE(),
[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
)
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!