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
Bookmarks