View Single Post
  #1   Report Post  
Rick
 
Posts: n/a
Default Insert date automatically

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