View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Emily[_3_] Emily[_3_] is offline
external usenet poster
 
Posts: 25
Default Function that compares dates and returns TRUE or FALSE

Hi,

I'll need to come up with a function that compares each value in column
D with '12/31/2005 ' and return TRUE if the value in column D is
smaller than '12/31/2005 ', but FALSE if it is greater than '12/31/2005
'.

I have the following formula:

=(D1<'12/31/2005')

But this gives me an error.

Also I'l need to know how to apply this formula to other rows. Thanks!

-Emily