Posted to microsoft.public.excel.worksheet.functions

jknapp1005 jknapp1005 is offline

external usenet poster

Posts: 25

Date functions

I'm trying to get a date function to return. If I put in NOW or TODAY it
returns a date of a passed or failed unit, but when I close the sheet out and
reopen, it refreshes the date. I need what's returned to remain the date of
the event. Formula I'm using is:

=IF(C101="PASS",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
Date functions	matchwalk	Excel Worksheet Functions	5	March 28th 07 01:34 PM
Date Functions	Jules	Excel Discussion (Misc queries)	4	July 5th 06 05:55 PM
Date Functions	KA Madrigal-Young	Excel Discussion (Misc queries)	1	January 24th 06 07:27 PM
date functions	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	6	January 5th 06 04:29 AM
Date functions	John	New Users to Excel	3	August 15th 05 08:50 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us