One lateral idea ..
Assume the 5 "day" col labels in C1:G1 are text:
Mon, Tue, Wed, Thu, Fri
with source data running in row2 down
Place in A1
=IF(ISNA(MATCH(TEXT(TODAY(),"ddd"),$C$1:$G$1,0)),"",OFFSET(C$1,ROWS($1:1)-1,MATCH(TEXT(TODAY(),"ddd"),$C$1:$G$1,0)-1))
Copy A1 down to cover the max expected extent of source data in cols C to G.
Col A will always return the required "Current day's" col. So you could hide
away cols C to G. As empty source cells will show as zeros in col A, for a
neater look you could suppress this via clicking Tools > Options > View tab,
uncheck Zero values > OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik