Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How can I check a cell for current date and insert it if blank?
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel automatically insert current date in a cell? | Excel Worksheet Functions | |||
Automatically insert a date value based on the value from another cell | Excel Worksheet Functions | |||
Insert date then lock cell! | Excel Discussion (Misc queries) | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
have a calendar pop up in a cell to pick & insert a date in excel | Excel Worksheet Functions |