Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
if statement

ResolvedVersion 2010

Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel Dashboards for Business Intelligence course

IF Statement

In Cell A2 I have a start date
The completion date in B2 is blank
In C2 I am simply calculating the days between B2 and A2, but because B2 is blank, C2 is showing a -42492 figure

How can I keep cell C2 blank " " whilst the completion date is unknown?

This is the formula I currently have that shows -42495

=IF(B2-A2=0," ",B2-A2)

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.