3

How can i get a minimum date of some columns with dates field.I know i can use the min function(formula) with numbers but not with dates. is this possible using calculated columns if not would i be able to do this using a workflow?

Thanks in Advance

1 Answer 1

2

You can also use the MIN() function for the dates in the calculated column to get the min date in a set of dates.

Here are my testing results:

Date and Time:

enter image description here

enter image description here

Date Only:

enter image description here

Update: Use ISBLANK() function.

Use the following formula:

If the one of the date fields (date1,date2,date3 ...) is empty, display empty instead of "30/12/1899".

=IF(OR(ISBLANK(date1),ISBLANK(date2),ISBLANK(date3)),"",MIN(date1,date2,date3))

enter image description here

Or use the following formula:

=IF(AND(ISBLANK(date1),ISBLANK(date2),ISBLANK(date3)),"",MIN(date1,date2,date3))

If all date fields are empty, show blank.

enter image description here

5
  • Thanks Joanna W. I Actually taught MIN function won't work for date.Will there be a way how i can check for empty fields before applying the MIN function.Because now it shows 30/12/1899 if the date values are empty
    – naijacoder
    Commented Nov 26, 2018 at 2:33
  • check my update in the answer. Commented Nov 26, 2018 at 2:58
  • Actually just tried that out using ISBLANK :) Thanks a lot
    – naijacoder
    Commented Nov 26, 2018 at 3:16
  • I have one more question though..i have a scenario where the first column is the only one with a date. In this case its showing blank how can I show the values instead of blank. Thanks
    – naijacoder
    Commented Dec 12, 2018 at 6:31
  • Check the last formula in my answer. =IF(AND(ISBLANK(date1),ISBLANK(date2),ISBLANK(date3)),"",MIN(date1,date2,date3)) Commented Dec 12, 2018 at 8:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.