Nested Formula

Dear Experts

I am totally hopeless with formulas and hope that someone can help me with what is probably a simple question.

Cells F2 & J2 should contain a date.
Cell K2 should show the number of days including the weekend between the 2 dates.

My problem is how to leave K2 blank if either or both of the 2 input cells are blank.

Your help would be gratefully received.



lapta301

Try this:
=IF(OR(F1="",I1=""),"",I1-F1)

=IF(OR(F4="",J4=""),"",YEARFRAC(F4,J4))
Assumeing that F4 is the starting and J4 is the ending dates