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?