If date is blank, do this. If date isn't blank, do this

Platform discussions Special workflows & use cases
1

Hello! I have tried everything, I have read several other items from the community and googled different options and I cant seem to make this work. I would love help!
I am trying to count days between dates based on an IF condition. If true then count the days between today and a date, if false then count the days between two dates. Has anyone had any luck with this?

Here is my attempt: IF({Term Date}<>0,DAYS(TODAY(),{Start Date}),DAYS({Term Date},{Start Date})

2

Hi @cfrancis-scofield,

Try

IF({Term Date}="",DAYS(TODAY(),{Start Date}),DAYS({Term Date},{Start Date}))
3

I was so close! Thank you so much!