Formulas using conditional "if" , "and", "or" according to dates

Occasional Visitor

Hello,

 

I'm looking for some help with one formula on the Excel database I'm working on (column Q).

It is about calculating the delay (in # days) between two dates. The problem with making this difference is that only one of them is fixed and the other varies (depending on the date). I

n the attached Excel I had to do it case by case (row by row) for column Q, but I'm looking for a formula to automate it.

Thank you in advance for your help and advice!

 

John

 

PS: I also had doubts about my column C and D formulas but they seem to work. Feel free to give me your opinion on them. Thank you!

2 Replies
Here is an example without an error display if there is no date in a cell.
=IF(ISERROR(DATEDIF(B2,A2,"d")),DATEDIF(A2,B2,"d"),DATEDIF(B2,A2,"d"))

I would be happy to know if I could help.

Nikolino
I know I don't know anything (Socrates)