How to add time or subtract time from a date when "check" is selected?

Shawn_K2

Hi!

Looking to see if this is possible. I have a packaging release date column that current pulls from another sheet for all items. I have items for Disney that I need to subtract 30 days when I click Disney checkbox column. When I uncheck the checkbox column, I want the date to revert back or add 30 days back.

Here is the current formula for the packaging release date is

=IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0)), "")

I'll then have a new checkbox column to trigger the 30 days.

heyjay

Can you try this:

=IF(Checkbox_Column@Row = 1 ,
IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0) + 30), ""), 
IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0)), ""))

Shawn_K2

@heyjay THANK YOU! Date changes but is not accurate.

Shawn_K2

@heyjay Ok I need a subtraction. I tried:

=IF(Checkbox_Column@Row = 1 ,IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0) - 30), ""), IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0)), ""))

But the date is subtracting by 3 months.

heyjay

Your formula seems correct. May I know what date are you using and what date is showing when you use the formula.

Shawn_K2

Before check

Checked off. Date is not 30 days before.

Formula

Paul Newcome

Your -30 is in the wrong spot. Try this one instead:

=IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0)) - IF([Column Name]@row = 1, 30, 0), "")

Shawn_K2

@Paul Newcome You the man!!! That worked! Thank you!

Paul Newcome

Happy to help. 👍️