Forum Discussion
If yes then countdown from 30
Hi guys/girls, Trying to figure out a formula for the following: If column a1 is "yes" then countdown in days in column b1 starts at 30 and counts down to -120 If no then countdown is same as C...
Hi Martin_Weiss thank you for this
I wanted the countdown to be done daily. Ie if today is 30 tomorrow is 29, drop 1 per day.
Not sure if this is possible
Hi Manik1920
so, B1 should start with the current day? Then you could use:
=IF(A1="yes";DAY(TODAY());C1+1)
And in A2 the same formula as in my first answer:
=IFERROR(IF(B1-1>-120;B1-1;"");"")
And if you have M365, you can use:
=IF(A1="yes";SEQUENCE(121+DAY(TODAY());1;DAY(TODAY());-1);SEQUENCE(C1+122;1;C1+1;-1))