Thread
:
How can I check a cell for current date and insert it if blank?
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
How can I check a cell for current date and insert it if blank?
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett