What is the Formula for: IF Submit Date is older than Start Date, Display X

**Sandcastle** · 04-22-2014, 05:14 PM

What is the Formula for:
IF Submit Date is older than Start Date, Display X
IF Submit Date is newer than Start Date, Display Y
IF either Date is blank, Display XY

Currently I am using a formula that is not giving me the results that I need:
=IF(AO18<AU18,"X","Y")

Part of my problem is that I don't think about the problem in the way that I need to write a formula.
The other part is that I am weak with formulas.

Thanks

**Melvinrobb** · 04-22-2014, 05:48 PM

Formula:

Please Login or Register  to view this content.

In the formula above, Y will display if submit date equals start date, as you haven't clarified what to do in those scenarios.

**Sandcastle** · 04-23-2014, 09:07 AM

Excellent, thank you!

What is the Formula for: IF Submit Date is older than Start Date, Display X

LinkBack

Thread Tools

Rate This Thread

Display

What is the Formula for: IF Submit Date is older than Start Date, Display X

Re: What is the Formula for: IF Submit Date is older than Start Date, Display X

Re: What is the Formula for: IF Submit Date is older than Start Date, Display X

Thread Information

Users Browsing this Thread

Similar Threads

Formula to find the target date from the start date with few criteria.

[SOLVED] IF & EDATE Formula together for an End Date but how to ignore text in start date cell

[SOLVED] Display all data within Start and end date

Date/turn start date cell red if completion date is blank or 28 day pass the statrt date

Button to prompt for date when click submit the date will append to link to get execute

Bookmarks

Bookmarks

Posting Permissions