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
---
"CevaClerkII" wrote:
I have created a work sheet with five columns, one for each day in the work
week. I want to hide the columns that are not the current day. I only need to
see the current day