Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula for dates
hello..
im looking for formula which will give me an output related to the date. heres what i am looking for. i have a list of work shifts in column A, and start date in column B and end date in column C. i need an output on a diff cell to tell me the shift thats working on the present day. SHIFTC 3/27/2007 7:00 3/27/2007 19:00 SHIFTD 3/27/2007 19:00 3/28/2007 7:00 SHIFTC 3/28/2007 7:00 3/28/2007 19:00 SHIFTB 3/28/2007 19:00 3/29/2007 7:00 SHIFTA 3/29/2007 7:00 3/29/2007 19:00 SHIFTB 3/29/2007 19:00 3/30/2007 7:00 SHIFTA 3/30/2007 7:00 3/30/2007 19:00 SHIFTD 3/30/2007 19:00 3/31/2007 7:00 the cell with the function would output SHIFTC as today is 3/27/2007 12:08 and then would change to SHIFTD when the time would change to 3/27/2007 19:00. can you help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for dates | Excel Discussion (Misc queries) | |||
How Do I Add Dates in a formula? | Excel Worksheet Functions | |||
how do I use if formula using dates? | Excel Worksheet Functions | |||
formula for dates | Excel Discussion (Misc queries) | |||
Dates in Formula | Excel Discussion (Misc queries) |