to enter today's date if a cell is blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need the formula or procedure to enter today's date if a cell is blank.
 
Hi Lynn

=if(a2="",today(),"")

hth
regards from Brazil
Marcelo

"Lynn Hanna" escreveu:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Calculating age from date of birth and ignoring if blank 5
Excel How to get the number of days an item was opened from the today's date. 14
If cell is blank automatically enter today's date in the same cell 21
Counting days comparing 2 dates excluding empty cells 4
Counting days from a date 3
Comparison of columns using Conditional Formatting 3
Ignore blank cells when calculating date for If, Then function 2

Back
Top