Thread: Less Than Greater Than Date Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
galimi galimi is offline
external usenet poster
  
Posts: 210
Default Less Than Greater Than Date Question
=if(A1<date(2006,1,1),"Yes","No")
--
http://HelpExcel.com




"Paperback Writer" wrote:

I need to put in a formula that simply says if a date in a cell is less than
a particular specified date. I'm fairly good with Excel, but I can't figure
this out. Major brain freeze, I'm sure.

Let's say A1 has 1/31/2005 in it. In B1 (and copy/pasted all the way down),
I want to show if A1, A2, A3, etc. is less than or equal to 1/1/2006. So, in
this case, B1 would show "YES".

Thoughts?
Reply With QuoteReply With Quote