Simple formula help

[Excel91]

Im trying to set up a document to show the differences in days between 2 cells = Example: A1 has a planned date, B1 has an Actual, C1 has the difference, i have used =B1-A1 in cell C1 but if cell B1 is empty it is bringing back a number of "45448", why is this? What is the best formula to use?

 

[SunnyAlv]

i think u just change format cell to Date / Short Date, or u can use #Text Formula, like

=IFERROR(TEXT(B1-A1,"DD MMM YYY"),A1)

 

[Excel91]

i think u just change format cell to Date / Short Date, or u can use #Text Formula, like

=IFERROR(TEXT(B1-A1,"DD MMM YYY"),A1)[/CODE
[/QUOTE]
Im not trying to get a date in Column C1, i need to know the differences in dates by amount of Days either early or late

 

[Fluff]

Hi & welcome to MrExcel.
What do you want to see if B1 is empty?

 

[Dave_george]

=IF(B1="", "", B1-A1)

Use this

 

[Excel91]

Hi & welcome to MrExcel.
What do you want to see if B1 is empty?

Just for it to be blank, and if B1 has a date that's different to A1 then the difference is shown in days late or early in C1

 

[Excel91]

=IF(B1="", "", B1-A1)

Use this

Nailed it. Thanks Dave!

 

[Excel91]

Done - Thanks all.