Hello. I've tried to search the web but can't find anything for my exact situation.

I'm trying to make a formula work with multiple conditions.


If A1 and B1 are blank C1 should be 0
If A1 is not blank and B1 is blank calculate the days from A1 to today
If A and B1 are not blank calculate the days between them.

Thanks in advance