How do I compare dates on Excel?

Answer by  Jaggers (1018)

Excel is not the best choice for this application but since you asked-load each dates good and bad traits side by side in a power point format.

Answer by  technogeek (6640)

If you are looking to see the difference between two dates in Excel, you have to format the dates so that they show as dates. Otherwise, they will show as the numerical equivalent that Excel created for each day. After formatting, you can then create a formula to determine whatever it is you are trying to know.

Answer by  demondread (59)

Use an "IF" statement. Example if you want check to see if the date in cell A1 is greater then the date in cell D2 you could use IF(A1>D2,"Keep","Discard".

Answer by  gigo (1706)

Just use the function equal or the corresponding translated word if you are not working with an english version of the program.

Answer by  knightmare (1231)

Format any cells with dates in them first. You can highlight a bunch and use the Format menu up top or from right clicking. Then calculations and comparisons will work.

Answer by  anilypsa (8)

if(A1 > A2, TRUE, FALSE) where first date is in A1 Cell and second date is in A2 Cell * you can also use other conditional operators for comparison. if is a conditional statement.