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 |
Since all your dates are the first of the month, aren't you really asking if
the month of any particular date is January? =IF(MONTH(A1)=1,"Yes","No") "Snaggle22" wrote: 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 |
Well actually I would just like to know if the cell with the date in it is
January 1st of any of the specific years in the column. For example, I could have 1-1-2006, 1-4-2006, 1-1-2007, 1-1-2008, 1-7-2008, etc. I just want January 1sts of each year. thanks in advance "Duke Carey" wrote: Since all your dates are the first of the month, aren't you really asking if the month of any particular date is January? =IF(MONTH(A1)=1,"Yes","No") "Snaggle22" wrote: 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 |
Nevermind, I got it. Thanks man!
"Snaggle22" wrote: Well actually I would just like to know if the cell with the date in it is January 1st of any of the specific years in the column. For example, I could have 1-1-2006, 1-4-2006, 1-1-2007, 1-1-2008, 1-7-2008, etc. I just want January 1sts of each year. thanks in advance "Duke Carey" wrote: Since all your dates are the first of the month, aren't you really asking if the month of any particular date is January? =IF(MONTH(A1)=1,"Yes","No") "Snaggle22" wrote: 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 |
All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com