Forum Discussion
Date difference calculation when it is blank
Hi, need help on data diff calculation when it is blank. For row1, I am able to find difference using datediff function. =datediff(date1,date4,day). but for remaining rows, when it is blank I ...
Anonymous , a new column
datediff([date1], coalesce([Date4],[Date3], [Date2]), day)
amitchandak
Super User
Super UserAnonymous , a new column
datediff([date1], coalesce([Date4],[Date3], [Date2]), day)
Perfect. You made my day easy. Thank u so much. amitchandak