multiple if functions in the same cell

[rooster2834]

Good afternoon,

I am trying to create a formula that "specifically" if cell B22 has a date in it that cell F10 stops adding the date from the previous cell (E10) however if there is a date in B22 then F10 stops counting (this is the easy part I have got this) now if cell C22 does not have a date in it but B22 does then I want o continue to pause but when C22 does have a date I want to count from the date in C22 (again, I have that formula working) how do I combine them to make cell F10 count +1 from E10 if B22 is blank but stop if it has a date and then return counting from C22 if C22 is not blank (I am working with dates)

=IF(ISBLANK(B22),E10+1,"") Works
=IF(NOT(ISBLANK(C22) Works

How do I combine them to make a single formula that works???

Thank you for any help that can be provided

 

[MrPink1986]

Does this work - =IF(B22="",E10+1,C22)

 

[rooster2834]

That worked great thank you.

Now when it populates the date when it stops counting it creates a date from "0Jan-00" and adds from there is there anyway to have it completely blank?

also I was wandering if I would be able to doth same thing with the cells below it "B23 and C23" and have it work with the previous formula in case I had multiple stops in one complaint?