How do I write a formula/function that uses whichever scenario is earliest?

Jesika McNeil

I have a sheet with two optional dates.

Something happens 45 days from the date something was received

or

Something happens 145 days from the date of an incident

Example. An incident occurs, and materials must be submitted. We then have to write a report within 45 days of the date the materials were submitted or within 45 days after 100 days post-incident (145 days total), whichever date is the earliest.

I believe it would be an if this or that statement, but how do I say whichever is the earliest date?

Paul Newcome

Do you already have formulas for the two separate dates? Have you looked into the MIN function?