Hi there.
I'm not sure if this can be done, but I thought I would ask.
I would like cell in D2 to add todays date when any text is entered into Colum A2 and not have that date update the next time I open the worksheet.
When I use =TODAY() the cell will update when ever I open the workbook.
Also I would like F2 to calculate 6 weeks from a date that I enter into E2 and change the entire row Yellow when that date is reached.
I'm not sure if this can be done, but I thought I would ask.
I would like cell in D2 to add todays date when any text is entered into Colum A2 and not have that date update the next time I open the worksheet.
When I use =TODAY() the cell will update when ever I open the workbook.
Also I would like F2 to calculate 6 weeks from a date that I enter into E2 and change the entire row Yellow when that date is reached.