Help with date formula

Need formula to calculate a date:

Spreadsheet has (3) Columns as follows:

Cal Type (drop down) with 2 options - In-house or Third-Party

Next Cal Date: Date

Reminder Date: Date

Would like formula to calculate the following If/then scenario:

If value in Cal Type is "Third Party" then need Reminder Date to be Next Cal Date - 30 days.

Thanks for your assistance

Find more posts tagged with

Formulas

Services

What do you want the reminder date to be if the option In House is selected?

Next Cal Date - 7 days

=IF([Cal Type]1="Third Party", [Next Cal Date]1-30, IF([Cal Type]1="In House", [Next Cal Date]1-7))

Should do the trick... Reminder column is a date column.

Mike:

That did the trick!

Thank you so much for taking time to help me with this.

Much Appreciated....

You're welcome!