Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bev Bev is offline
external usenet poster
 
Posts: 28
Default If Function with Dates

I have the following formula - which works correctly,
=IF(F6<--"2005-01-01","No","Yes"), F6 is a date ... my question is, what does
the -- signify in the equation?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default If Function with Dates

Just making the text string 2005-01-01 into a number that can be compared
with another number

--


Regards,


Peo Sjoblom

"Bev" wrote in message
...
I have the following formula - which works correctly,
=IF(F6<--"2005-01-01","No","Yes"), F6 is a date ... my question is, what
does
the -- signify in the equation?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Using IF Function on Dates Darin Excel Discussion (Misc queries) 1 September 12th 08 10:12 PM
If Function and Dates Laura Logan Excel Worksheet Functions 13 March 12th 08 01:31 PM
IF function and DATES Excel_Oz Excel Worksheet Functions 6 February 21st 07 04:17 AM
IF function using dates ? barnsey11 Excel Worksheet Functions 2 January 15th 06 04:01 PM
if function with dates Brad Excel Discussion (Misc queries) 1 January 10th 05 10:49 PM


All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"