Posted to microsoft.public.excel.worksheet.functions

Carl Gross Carl Gross is offline

external usenet poster

Posts: 1

Date trouble

cell A2 has the date 3/9/2007

When I test the following formula - =(A2+45)=4/27/2007 I get True, but I
should get false.

AlSO, when I put in =4/23/2007<4/27/2007 I get false. Both expressions
should evaluate to true.

What is going on?

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 trouble	BoniM	Excel Worksheet Functions	0	January 10th 07 12:53 AM
Trouble formatting date	geordy67	Excel Worksheet Functions	6	July 27th 06 02:30 AM
Trouble formatting Date data	LB	Charts and Charting in Excel	1	May 1st 06 12:11 PM
Excel date format trouble	michaelberrier	Excel Discussion (Misc queries)	2	April 21st 06 05:21 AM
trouble with date	dada	Excel Worksheet Functions	1	July 3rd 05 06:07 AM

All times are GMT +1. The time now is 02:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us