Thread: If Statements with Dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default If Statements with Dates
TRY:

=IF(B1DATEVALUE("15/9/06"),"true","")

"Erika" wrote:

I am trying to build a If statement using dates, I am getting all True the
forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06

What am I doing wrong?

Reply With QuoteReply With Quote