Home/ Questions/Q 6898
Next
In Process
Computing Staff
  • 6
Asked: 2021-11-22T02:49:08+00:00 In:

Compare Two Columns In Excel 2003

  • 6

I am trying to compare two columns using Excel 2003. Both columns are dates along with times. I am trying to determine if the date in the second column is greater than 5 days compared to the first column.

Example:
A B
1/1/2011 12:00 1/12/2011 17:30

Is there a way to highlight this row because column B is more than 5 days?

I used:

=IF($D$13>=$B$13+5,TRUE,FALSE)

The date and time start on columns D and B and the rows are in the 1000s. I added that formula and used the paste special feature, selecting formats, but nothing happens.

Thanks!

Share

    1 Answer

    1. if the date in the second column is greater than 5 days compared to the first column.

      So using your example date:

      $D$13 = 1/12/2011 17:30

      $B$13 = 1/1/2011 12:00

      I first highlighted cells A13 through P13.

      And using your formula: =IF($D$13>=$B$13+5,TRUE,FALSE)
      it worked for me.

      I highlighted cells A13 through P13.

      MIKE

      http://www.skeptic.com/

      • 0