Calculate difference between dates if populated, return a different result if not

Kristen Bell

Hello, newcomer here!

Trying to work out the best way to calculate the following please:

If Date X = blank, return result 'overdue'

If Date X = populated, calculate difference between Date X and Y

Following on from that, I need a following column to return Yes if date is <1, or No if date is or overdue.

Thanks in advance!!

Kristen

Paul Newcome

For the first, you can try something along the lines of...

=IF([Date X]@row = "", "Overdue", [Date X]@row - [Date Y]@row)

And for the second you can use...

=IF([Calculated Column]@row < 1, "Yes", "No")

Kristen Bell

Thank you Paul, worked great and gave me ideas to fix other problems I was having!

#constantlylearning!😁

Paul Newcome

For the first, you can try something along the lines of...

=IF([Date X]@row = "", "Overdue", [Date X]@row - [Date Y]@row)

And for the second you can use...

=IF([Calculated Column]@row < 1, "Yes", "No")

Kristen Bell

Thank you Paul, worked great and gave me ideas to fix other problems I was having!

#constantlylearning!😁

Paul Newcome

Happy to help! 👍️

#thatmakes2ofus 🤣