I'm trying to create a "duration" Column from a spreadsheet that allows for a returning a "0" if both "start date" and "end date" columns are blank. So far I've got the following which calculates duration and also returns a value using the current date if "End Date" is empty, so i just need to know how to add to this formula to get a "0" if there no date in either column:
=IF(ISBLANK([@[PoP End]]),TODAY()-[@[PoP Start]],[@[PoP End]]-[@[PoP Start]])
Thanks in advance!
=IF(ISBLANK([@[PoP End]]),TODAY()-[@[PoP Start]],[@[PoP End]]-[@[PoP Start]])
Thanks in advance!