Posted to microsoft.public.excel.misc

external usenet poster

Posts: 40

Insert Date

I am trying to figure out a simple formula that when a user inserts
his initials into a cell the cell next to it gets the date
corresponding to the day he filled out his initials. This is what I
have

=IF(ISBLANK(D6),"",Date)

Thanks

Reply With Quote

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
How can I insert a date with an icon (calendar) insert	Alfredo Mederico[_2_]	Excel Discussion (Misc queries)	4	September 21st 07 01:20 AM
insert date	Larry	Excel Worksheet Functions	28	July 15th 06 02:41 AM
Insert new date once.	Eric Vogel	Excel Worksheet Functions	1	July 6th 06 04:17 PM
Insert Hebrew Date	yossele	Excel Worksheet Functions	1	May 27th 05 08:20 PM
Automatically Insert DATE, so that DATE will NOT change	Cie	Excel Worksheet Functions	4	April 4th 05 05:51 PM

All times are GMT +1. The time now is 03:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us