date comparison

S

Scott M

I'm trying to compare two dates within an "if" statement
and having some difficulty.
I only want to execute the true statement if the date is
later than today's date... I tried using the "datedif"
function but it seems that it requires the first cell date
to be earlier than the second and in my data that's not
always going to be the case. It sounds pretty easy to me
but I can't seem to find the solution... thanks for the
help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
IF(AND with date comparison 4
Using external query (mdb) for dynamic date range 2
calculate fractions using dates 6
identify which years are contained within a range of dates 2
Conditional Format Tracker by Date 0
Date comparisons within AND() functions 2
Need help with formulae comparing date-based numbers 2

Top