Posted to microsoft.public.excel.worksheet.functions

Lynn Hanna Lynn Hanna is offline

external usenet poster

Posts: 1

to enter today's date if a cell is blank

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
insert date	Larry	Excel Worksheet Functions	28	July 15th 06 02:41 AM
Custom functions calculating time arguments Help Desperate	Bill_De	Excel Worksheet Functions	12	April 25th 06 02:22 AM
Number of days between 2 dates, if end date is blank assume todays	JulesM	New Users to Excel	1	March 1st 06 12:41 PM
Create a button that will date stamp todays date in a cell	Tom Meacham	Excel Discussion (Misc queries)	3	January 11th 06 01:08 AM
In Excel, Get todays date in a cell	tbw	Excel Discussion (Misc queries)	2	October 6th 05 12:08 AM

All times are GMT +1. The time now is 08:21 AM.

About Us

"It's about Microsoft Excel"