Thread: IF and AND formula for date field
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
jasontferrell jasontferrell is offline
external usenet poster
  
Posts: 56
Default IF and AND formula for date field
Yes, this will do it.
=IF(B2<DATEVALUE("01/02/2009"),YEAR(B2),IF(B2DATEVALUE
("01/01/2010"),YEAR(B2),"2009Q"&(INT(MONTH(B2)/4)+1)))
Reply With QuoteReply With Quote