Calculating number of days between events
I am trying to figure out how to calculate the number of days between events and if one of the events is blank, it does not calculate.
I have the following fields (some of which may be left blank as it is not related to this project):
Start date, completion date, deadline date, plan started, grant started on, execution date, publication date
I would like to calculate:
Start date to execution
Start date to publishing
Start date to deadline
Start date to grant
Execution date to publishing date
Right now when I enter only a start date and deadline date (leaving other fields blank), it automatically fills in -735415 for the other fields. I would like the field to be blank.
I have the calculations set up correctly as if I fill in every field, the calculation is correct. It is just when I leave something blank it enters the negative number.
Can someone help me? Please let me know if I need to clarify something. I have attached a picture if that helps.
Kirsten assistant to Victor