format a cell that i want to use [SOLVED]

[ace_silver10]

Hi there,

what im after is how to format a cell that I want to put a value in,

Im after, in date format, in the B1 cell... if A1 is the same date as B1 then dont show a value in B1, if B1 is different

B1 - A1 = C1 ( A1 = 09/05/2015, B1 = 10/05/2015 so C1 will = 1) but... if B1 doesnt have a date then I want B1 to be blank and C1 to be blank

then i had to s............................................... ALL GOOD I GOT IT (in the C1 cell) =IF(B1="","",SUM(B1-A1))

Even better I figured it out myself

[benishiryo]

hi ace_silver10. glad you have solved your problem. you could even exclude the SUM.
=IF(B1="","",B1-A1)

[FDibbins]

For what it's worth, you really dont need to use SUM to subtract 2 cells, you can just use...
=IF(B1="","",B1-A1)

[ace_silver10]

Oh well, now i know, and as you guys mention it i completely understand. Thanks

[FDibbins]

Apart from that, great job there