Posted to microsoft.public.excel.misc

TechGuy[_2_] TechGuy[_2_] is offline

external usenet poster

Posts: 4

Inserting date from formuls

Hi all,

I have a data verification drop down created and I am trying to make the
date poplate in certain cells depending on my drop down choice. The main
thing I have found for this would be the "today()" value. The problem with
this though is that the date changes daily. I need this to be a static value.
Any help would be great. Thanks.

=IF(K8="closed", TODAY())

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
Formuls to turn date red	John M.	Excel Discussion (Misc queries)	1	January 27th 07 06:02 PM
Formating Font in a Formuls	Silvanus	New Users to Excel	5	December 9th 05 03:22 PM
Formuls updating	Adam	Excel Worksheet Functions	2	October 19th 05 07:49 PM
how do I do a formuls in excel such as (if a1=somthing then b1=a .	Brett	Excel Worksheet Functions	3	January 9th 05 08:15 PM
making a column of formuls constant	Jake	Excel Worksheet Functions	2	November 2nd 04 01:45 AM

All times are GMT +1. The time now is 04:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us