Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
How do you extract the first value (plus the date) of each month out of a series? Example 2/4/05 data 2/12/05 data 2/13/05 data 3/1/05 data 3/2/05 data etc In this sample I only want to pull: 2/4/05 data 3/1/05 data In reality I have a large dataset I am working with (15 years with weekly entries). I just want to pull the first value (and date) of each month. Thanks in advance for any help. Al |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting month from a date field | Excel Discussion (Misc queries) | |||
Extracting month as text | Excel Worksheet Functions | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions |