Greetings -
I have a Date column (A) and a Serial Number column (B). I would like the Date column to be blank, unless a Serial Number is entered in column B. When a Serial Number is entered, I would like the date to be automatically populated. e.g., I put a serial number in B2 and today's date appears in A2.
In the Date column, I tried =IF(ISBLANK(B11),"",TODAY()) which works fine...today. But tomorrow if I enter a new serial number in B3, then all the dates in column A change to tomorrow's date!
I'm certain there must be a way to do this, I just don't know what it is. Any help from you Excel gurus out there would be most appreciated.
I have a Date column (A) and a Serial Number column (B). I would like the Date column to be blank, unless a Serial Number is entered in column B. When a Serial Number is entered, I would like the date to be automatically populated. e.g., I put a serial number in B2 and today's date appears in A2.
In the Date column, I tried =IF(ISBLANK(B11),"",TODAY()) which works fine...today. But tomorrow if I enter a new serial number in B3, then all the dates in column A change to tomorrow's date!
I'm certain there must be a way to do this, I just don't know what it is. Any help from you Excel gurus out there would be most appreciated.