Change value of a cell based on the date in another cell.
Hello,
I am trying to set up an Excel sheet for work. In column E, there is a date for each row. If that cell’s date is less than or equal to one year from today’s date, I need it to change the value of column C to “1”. If it is greater than one year away, column C needs to be “2”
Is this possible to do?
Hello, I am trying to set up an Excel sheet for work. In column E, there is a date for each row. If that cell’s date is less than or equal to one year from today’s date, I need it to change the value of column C to “1”. If it is greater than one year away, column C needs to be “2” Is this possible to do? Read More