What kind of a date formula can you create to add a specified number of days to a date?
You need to use the Relative Date function as in the examples below. You don’t need a plus (+) to add days, but you do need a minus (-) to subtract them.
Date minus 7: =RelativeDate([Account End (FC)];-7)