S SharH New Member Feb 17, 2015 #1 Hello ! I am trying to compare 2 dates and which one is more recent. For example A1= 02/17/15 & A2= 02/16/15 so If(A1>A2, recent, old) This however is not working. How can I modify the formula for it to work? Thanks!
Hello ! I am trying to compare 2 dates and which one is more recent. For example A1= 02/17/15 & A2= 02/16/15 so If(A1>A2, recent, old) This however is not working. How can I modify the formula for it to work? Thanks!
Luke M Excel Ninja Staff member Feb 17, 2015 #2 Welcome to the forum SharH! I'm guessing you need to put quotation marks around the words. Formula would be: =IF(A1>A2,"recent","old")
Welcome to the forum SharH! I'm guessing you need to put quotation marks around the words. Formula would be: =IF(A1>A2,"recent","old")
S SharH New Member Feb 17, 2015 #3 Luke M said: Welcome to the forum SharH! I'm guessing you need to put quotation marks around the words. Formula would be: =IF(A1>A2,"recent","old") Click to expand... Thanks for the welcome Luke! Well that was simpler than expected. Thanks for the help. Appreciate it!
Luke M said: Welcome to the forum SharH! I'm guessing you need to put quotation marks around the words. Formula would be: =IF(A1>A2,"recent","old") Click to expand... Thanks for the welcome Luke! Well that was simpler than expected. Thanks for the help. Appreciate it!
