Hey there, first post! I am trying to write a formula that choses the later of two dates. Date 1 is always present. Date 2 may be blank so it should give me Date 1. Date 2 may be later than Date 1 so I want it to show date 2.
I cant use the MAX function since it will only return numbers.
Welcome to the community.
Try this:
FORMAT_DATE(IF(AND({Date 2}, FORMAT_DATE({Date 1}, "YYYY-MM-DD") < FORMAT_DATE({Date 2}, "YYYY-MM-DD")), {Date 2}, {Date 1}))
Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday
YES! This is exactly what I needed and worked perfectly! Thank you so much!
Only to realize I can’t use this Date as a Date anywhere else in Monday. Like a timeline view…hopefully this will get addressed, but at least I have the dates I need for reporting
You can use an IF statement combined with ISBLANK to handle this. The formula would look something like this:=IF(ISBLANK(Date2), Date1, IF(Date2 > Date1, Date2, Date1))This will return Date 1 if Date 2 is blank, and it will return Date 2 if it’s later than Date 1. If Date 2 is earlier or the same, it will give you Date 1.I remember running into a similar issue while working on a project tracking vehicle maintenance dates. I needed to get the later of two dates to track when a car was due for service. This formula saved me a lot of time! Also, if you want to level up your Excel skills, excel.tv has some great tutorials that really helped me with stuff like this.