Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-25-2014, 08:35 PM
zarkadasa zarkadasa is offline Help needed with If/Then statement Windows 7 32bit Help needed with If/Then statement Office 2007
Novice
Help needed with If/Then statement
 
Join Date: Nov 2013
Posts: 8
zarkadasa is on a distinguished road
Default Help needed with If/Then statement

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help needed with If/Then statement Need help with If, Then Statement Please cangelis Excel 4 01-03-2014 09:10 AM
Help needed with If/Then statement Syntax Help Needed for Using AND Statement in NEXIF robpgreer Mail Merge 10 08-11-2011 04:58 PM
Help needed with If/Then statement Help with IF Statement limpbizkit Excel 4 02-24-2011 09:16 PM
Help needed with If/Then statement if statement piper7971 PowerPoint 1 08-19-2010 07:10 AM
Help needed with If/Then statement Help with IF statement! CPelkey Word 1 04-12-2010 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft