Posted to microsoft.public.excel.programming

Neall

external usenet poster

Posts: 95

Why are my date results incorrect

When use the SQL editor tool in excel and retieve my data. the correct date
format shows, when I import it into excel the correct format shows, but when
I try to use a formula the date shows up as a number

example date shows as 8/2/2007 but when I try to use the countif I see this
in the formula displays 39296

I am thinking this is why my count if statement is not working

--
Neall

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
Goalseek gives incorrect results	dindigul	New Users to Excel	1	July 12th 09 12:14 AM
results incorrect	KMC	Excel Discussion (Misc queries)	2	July 18th 08 03:14 PM
vlookup gives incorrect results	Forrest G.	Excel Worksheet Functions	3	December 18th 06 05:40 PM
Excel NETWORKDAYS - incorrect results	Patricia[_4_]	Excel Programming	2	April 19th 05 01:01 PM
Application.Filesearch yields incorrect results??	Ed[_23_]	Excel Programming	2	August 24th 04 08:59 PM

All times are GMT +1. The time now is 03:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us