Help with date formula

rbarnes15506

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

 

Mike Wilday

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

rbarnes15506

Next Cal Date - 7 days

Mike Wilday

=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. 

 

rbarnes15506

Mike:

That did the trick!

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

Much Appreciated....

Mike Wilday

You're welcome!