Formula – Subtract Days from Existing Date to Create New Date

[dneale (Dan)]

Does anyone have a formula to minus a certain amount of days from an existing ‘Date’ column to create a new date that certain amount of days earlier. There was a tread that added days to from an existing date – RIGHT(LEFT(CONCATENATE(WORKDAY({Date}, 8)), 15), 11)

Any help is appreciated

[timlittletech (Tim Little)]

If we wanted to subtract 15 days instead, we would use the function SUBTRACT_DAYS()

SUBTRACT_DAYS({Start Date},15)

where '{Start Date} is your existing {Date Column}

Hope that helps

[dneale (Dan)]

Hi Tm

Thanks for the help on this one…… does this do calendar days or workdays???

[timlittletech (Tim Little)]

Hey Dan, sorry I meant to post the link to formula where I pulled that information from.
here is the reference: https://support.monday.com/hc/en-us/articles/360001276465-List-of-all-available-formulas

After a quick test, that formula uses calendar days, not work days.