View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Don K Don K is offline
external usenet poster
 
Posts: 1
Default How can I check a cell for current date and insert it if blank

Hello DOn,

I appologize, but I'm pretty new to this and don't understand your
instructions

"Don Guillett" wrote:

Sub insertdate()
With ActiveCell
If Not IsDate(.Value) Then .Value = Date
End With

--
Don Guillett
SalesAid Software

"Don K" <Don
wrote in message
...
I am modifying the invoice template. I want to create a formaula that
checks
the date cell for the current date. If a date occupies the cell nothing
happens, otherwise, the current date is inserted. Can this be done?

Thanks
Don