Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a column with values such as:
3/25 3/24 3/29 3/21 3/21 3/21 And wish to automatically add todays date if the value of the cell is blank in the mm/dd format. I have used an =If(Column:Column="",TODAY()) in a column next to it and formatted it in mm/dd to get the desired result. But how can I take this value (todays date) and insert it back into the original column automatically and without changing the other valuse? As always thank you! Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Challenging Charting | Charts and Charting in Excel | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |