View Single Post
  #1   Report Post  
Snaggle22
 
Posts: n/a
Default How to lookup the dates of a list that are only the first of the .

If I have a list of dates in a column that start with 1/1/2006 and goes to
1/1/2025, with each date being the first of the month for ex: 1/1/2006 then
2/1/2006......1/1/2025, how do I lookup just the dates that are the FIRST of
the year. For example: I want to put a 'yes' in the next column if the date
is the first of the year and a 'no' if it isn't. Thanks