Home // Blog & Excel Tips // Excel IF date greater than

Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

 
2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.

 

Excel IF date greater than

Comments Closed
Uncategorised

Excel IF date greater than

A common check required in business is if date greater than another date say yes otherwise no or something along those lines (overdue/ current etc). This is easily achieved with the IF function.

What people typically don’t understand is that Excel is comparing 2 numbers and as a result it is very important that the dates you are referring to are valid dates per Excel.

We have blogged repeatedly on the date issue and you can see more here.

The actual IF function is simple (if you need to know how to use the IF function please do our free Fundamentals course).

Assuming that in A1 you have the (Excel valid) date 5 Jan 2015 and in B1 you have the (Excel valid) date 6 Jan 2015, the formula in C1 would be

=IF(B1>A1,”Overdue”,”Current”)

As long as the 2 dates in A1 and B1 are valid, this formula will work well.