| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Value based on Day of Week
I have the following situation:
I'm trying to key off of the agent ID in Column A and based on todays day of the week return the start time of the agent from column D. I can index it to get me the start time, but don't know how to formulate the date part of the equation. Any help would be greatly appreciated! Agent ID Agent Name Day Start Stop --------- -------------------- --- ------ ------ 2012069 Abel, Richard Howard Sun 18:00 0:00 Mon 18:00 0:00 Tue 18:00 0:00 Wed 18:00 0:00 Thu 18:00 0:00 Fri -OFF-- -OFF-- Sat -OFF-- -OFF-- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return dates based on month and day of week | Excel Worksheet Functions | |||
| How to return week number from date? | Excel Worksheet Functions | |||
| How to return week number from date? | Excel Worksheet Functions | |||
| Return day of week for 1 January | Excel Worksheet Functions | |||
| Return the day of week for 1 January | About this forum | |||
Threaded Mode
