Solved Comparing a date in column against today's date

April 21, 2014 at 10:27:36
Specs: Windows 7
In excel I am trying to compare a column of various dates against the current date (reported in one cell using the =today() function) and if the dates in the column is past today's date it will report "Late" in the adjacent row or if the date in the column is the same as the current date it will report "Due" in the adjacent row. "If/then" doesnt seem to work. I have thousands of columns of dates but simplied example

Current Date = 04/21/2014
Column A, Column B,
Due Date, Status,
04/12/2014, Late
04/21/2014, Due


See More: Comparing a date in column against todays date

Report •


#1
April 21, 2014 at 12:33:44
✔ Best Answer
First, a posting tip...

If you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the columns line up and your data is easier for us to read. It may take some trial and error via the Preview screen, as explained in the instructions, but it can be done.

Second, you told us what you want if the date to be checked has past or is the same as TODAY(), but you didn't tell us what you want if the date is later than TODAY().

I assumed you want a blank cell.


        A                         B
1    =TODAY()
2    Due Date                   Status
3    4/12/2014          =IF(A3<$A$1,"Late",IF(A3=$A$1,"Due",""))
4    4/21/2014          =IF(A4<$A$1,"Late",IF(A4=$A$1,"Due",""))  

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
April 21, 2014 at 12:50:47
Thank you DerbyDad03! That did it. Frustration subsiding now.

Report •

Related Solutions


Ask Question