Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i print a list of names and dates in excel into a two-colu. | Excel Discussion (Misc queries) | |||
Lookup with two variable data list cells | Excel Worksheet Functions | |||
FILTER OUT DATES IN LIST | Excel Worksheet Functions | |||
have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
Lookup a date between other dates | Excel Worksheet Functions |