Posted to microsoft.public.excel.programming

goober[_7_] goober[_7_] is offline

external usenet poster

Posts: 1

Getting system date

=IF(AND(A12,B15,((TODAY()-C1)/365)3),"GOOD",IF(AND(A12,B15,((TODAY()-C1)/365)<3),"BAD","Unknown"))

This should work for you. Aren't formulas fun.

--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=479422

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
Convert military date system to standard date system	John Weaver	Excel Discussion (Misc queries)	8	September 17th 09 06:12 PM
Difference betwen Excel Date () Function and System Date	Khalil[_2_]	Excel Worksheet Functions	2	June 16th 09 01:10 PM
Difference System date and Excel Date function	Khalil	Excel Worksheet Functions	2	June 16th 09 11:23 AM
Date system	mike	Excel Discussion (Misc queries)	8	March 3rd 08 11:46 AM
date system	The Rook[_2_]	Excel Discussion (Misc queries)	1	March 15th 07 12:04 PM

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

About Us

"It's about Microsoft Excel"