Date counter

[Wharbin]

Good morning, so I am trying to count days between two dates. My issue is if the cell I want to use is blank then I want excel to utilize another cell with a date in it to generate a count. The formula I am using is =C2-A2 which generates a date count but I want to add if cell C2 is blank the use cell B2 and the new date result would be B2-A2. I have added a pic of the excel I’m working on.

thanks,

 

[Fluff]

Hi & welcome to MrExcel.
How about
=if(C2="",B2,C2)-A2

 

[Wharbin]

In case no one tells you today, YOU’RE AWESOME! Thank you, that works perfectly!

 

[Fluff]

You're welcome & thanks for the feedback.