Thread: Referencing year portion of date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Allison Allison is offline
external usenet poster
  
Posts: 40
Default Referencing year portion of date
Thank you.

"ArthurJ" wrote:

A B
1 3/1/2005 =year(A1)=A$5 False
2 10/5/2008 True
3 4/9/2003 False
4
5 2008

Enter the formula shown in cell B1 and copied it down.
It will evaluate as shown.

Art
Reply With QuoteReply With Quote