![]() |
|
#1
|
|||
|
|||
|
Excel spreadsheet with three column dates
10/11/2012 12/31/2010 8/17/2013 2/25/2013 4/30/2010 7/11/2013 8/15/2012 3/31/2010 2/4/2013 5/25/2012 6/30/2010 2/16/2013 10/15/2012 2/28/2010 3/12/2013 6/21/2012 5/31/2010 2/23/2013 6/28/2012 4/30/2010 2/13/2013 2/17/2010 2/28/2010 10/18/2010 What I need to do is if the dates in the both the first and second columns are older than three years from the date of the third column, a yes next to that row should be inserted. I can sort and extract the ones I need from that. I'm sure it's simple for you guys--not so much for me. Last edited by macropod; 03-26-2014 at 12:08 AM. Reason: Reformatted continuous date string into three columns |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Need help with If, Then Statement Please
|
cangelis | Excel | 4 | 01-03-2014 09:10 AM |
Syntax Help Needed for Using AND Statement in NEXIF
|
robpgreer | Mail Merge | 10 | 08-11-2011 04:58 PM |
Help with IF Statement
|
limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |
if statement
|
piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |
Help with IF statement!
|
CPelkey | Word | 1 | 04-12-2010 09:06 AM |