LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 29
Default Date Function needed

I'm running into a problem with putting a date in a form i'm making.
I want to have todays date populate a cell when the form is opened.
But only once. So if a person opens the form for the first time it
populates todays date... today(). But if they open the form up again
that date will not change. If you use =today() then each time you
open the form up it populates that cell with today’s date.

Any idea's how i can code a cell with today’s date upon creation but
not have it change each time the form is opened.

Thanks for the help,
Steve
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Help needed on Date formulas shminas Excel Worksheet Functions 1 April 30th 06 11:05 AM
Date formula needed Rich Hayes Excel Worksheet Functions 4 December 9th 05 07:25 PM
Date formula needed VDan Excel Discussion (Misc queries) 4 August 31st 05 04:01 PM
Help needed with date format [email protected] Excel Discussion (Misc queries) 1 August 29th 05 09:11 AM
Date formulas needed David Excel Discussion (Misc queries) 9 July 24th 05 02:01 AM


All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"