Forum Discussion

Raholl2624's avatar
Raholl2624
Copper Contributor
Aug 02, 2022

Comparison values

Hi, can someone help with the formula to extract (or filter on) a column containing dates where the value is greater than the date column before it?

Many Thanks

Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Aug 02, 2022
    Use FILTER() function. Show few sample data then desired output. Edit and attach a sample file to your post.
    • Raholl2624's avatar
      Raholl2624
      Copper Contributor
      Aug 02, 2022

      Harun24HR 

       

      I need to filter on the Actual end date where it is greater than the planned end date

      Planned start date   Planned end date   Actual end
      01-Jan-22 04:30:00 01-Jan-22 07:30:00 01-Jan-22 04:40:19
      01-Jan-22 06:15:00 01-Jan-22 08:00:00 01-Jan-22 07:03:43
      01-Jan-22 07:00:00 01-Jan-22 09:00:00 01-Jan-22 07:25:46

Resources