Excel Formula for Entering Today's Date if Cell is Blank
Here's the corrected formula:
Formula:
=IF(ISBLANK(M10),TODAY(),M10)
This formula checks if cell M10 is blank. If it is, it enters today's date using the
TODAY() function. If it's not blank, it simply returns the value that's already in the cell.
To use this formula, simply copy and paste it into the cell where you want the date to appear (in this case, M10). Once you've done that, the cell will automatically update with today's date if it's left blank.
- Copy and paste the formula into the cell where you want the date to appear (in this case, M10).
- The cell will automatically update with today's date if it's left blank.
I hope that helps!