I am trying to calculate number of days record is "open". If no end date is available I am using Today's Date for the calculation.
3 columns in my example
[P] = Start Date
[Q] = End Date
[R] = Days Record Open Formula:
=IF(AND(P2<>"", Q2<>""), (Q2-P2), IF(AND(P2<>"", Q2=""), (TODAY()-P2), 0))
Everything calculates correct. But... when a new row is added to the table, column [R] shows "44248". I would like it to show "0".
However, If I enter a value in column [P], then immediately delete it... column [R] then shows "0" as I want it. Why do I have to trigger it? Can I make this default to zero when a new row is added to the table before any data is initially inputted for [P] and [Q] ?
Thanks,
3 columns in my example
[P] = Start Date
[Q] = End Date
[R] = Days Record Open Formula:
=IF(AND(P2<>"", Q2<>""), (Q2-P2), IF(AND(P2<>"", Q2=""), (TODAY()-P2), 0))
Everything calculates correct. But... when a new row is added to the table, column [R] shows "44248". I would like it to show "0".
However, If I enter a value in column [P], then immediately delete it... column [R] then shows "0" as I want it. Why do I have to trigger it? Can I make this default to zero when a new row is added to the table before any data is initially inputted for [P] and [Q] ?
Thanks,