Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Hi, Rick: Here's one way.
Step 1 is to make a backup of your original file so you have a fallback in case something goes horribly wrong. Assuming your date column is currently A, insert a new column to the right of that: call it column B. Enter a formula in column B for each relevant cell in column A: =IF(A1="",TODAY(),A1) .... then copy this formula for the remaining cells. This will use today's date for blank cells, but will show the existing date if the cell is not blank. Copy the new column and paste it as values into column A. The original values will be right where they started, and the blanks will now be filled with today's date. |
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 |