| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date Range and Time Range IF Statment
Hello All, this is my first time posting and saw all the great help people have done for others and figured i might give it a shot!
I am in advertising and am trying to do some trending, I am trying to find certain data with specific date and time ranges which are called dayparts. For example, I have a bunch of data over the course of a couple of months that I am looking to find out all shows that aired Monday through Friday from 6PM to 11PM. I have tried a bunch of things but I cant figure out how to do it properly, If any one knows how to do this i would greatly appreciate the help. Thanks a lot! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Range and Time Range IF Statment
We ned to know the format of your data. For example, is there a column for date or day? Is thee a separate column for time ? What are the columns ?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate within a time range with only start date and end date | Excel Worksheet Functions | |||
| Refer to Date/Time Range | Excel Worksheet Functions | |||
| Time Date Stamp when range changes | Excel Programming | |||
| variable range in a COUNTIF statment | Excel Programming | |||
| Date Range for my time sheet | Excel Worksheet Functions | |||
Linear Mode
