Download the featured file here https://www.bluepecantraining.com/excel-if-date-is-before-or-after-another-date-if-date-is-before-or-after-today/

In this video, I demonstrate how to use dates within an IF formula. I want to be able to compare two dates to find if one date is before or after another date. I also want to be able to calculate whether a date is after or before today's date.

You can compare two dates when they are both entered into cells or when one is hard-coded into the formula. Hard-coding a date into an IF formula is not as straightforward as you might think.

TABLE OF CONTENTS

00:20 - Compare dates when both dates are stored in cells
02:36 - Compare dates when one date is in the formula
04:34 - Compare to today's date
------------------------