Thread: to enter today's date if a cell is blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
  
Posts: 1,047
Default to enter today's date if a cell is blank
Hi Lynn

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

hth
regards from Brazil
Marcelo

"Lynn Hanna" escreveu:

I need the formula or procedure to enter today's date if a cell is blank.
Reply With QuoteReply With Quote