Help with working out date differences

[voniom]

Hello, I am trying to have two dates compared to show the number of days between which I can do.

Currently the columns I have are:
[INDENT] A Start Date[INDENT] B End Date[INDENT] C Duration

I also want to add that if there is only a start date and no end date, I would like the formula to return the result of days as if the end date was displaying the current date.

Is this possible.....?!?

Thank you in advance, look forward to your assistance :-)

[Sam Capricci]

it is possible, but depends on what the formula is you are using. You would just have to add TODAY() to the formula somehow. So seeing your formula and your desired output would help.

[Sam Capricci]

Something like =IF(END DATE = "",TODAY()-START DATE,END DATE - START DATE)
as an example