a date from date w/exception of when empty - SOLVED

User avatar
teachesms
2StarLounger
Posts: 170
Joined: 05 Feb 2010, 18:04
Location: Jacksonville, NC

a date from date w/exception of when empty - SOLVED

Post by teachesms »

What I want is: "Days Past Delivery Date" column to track how many days the "Act Comp Date" is past the "Req Comp Date", and am using the formula: =IF(F2<E2,E2-F2,"") in the example I am sending in cell G2. However, when there is no date in column F to do the calculation on, I want nothing to show up as the answer in column G. I remember using an NA function, but forget how to place it. Could you help?

Thanks,
(see example pic)

Think I fixed it...

=IF(F2<>"",E2-F2,"")
You do not have the required permissions to view the files attached to this post.
If you can't convince them, confuse them - Harry S. Truman

Nannette