Hide Cells Based on Weekday Value

Hi all!

Thanks for taking the time to read this.

I'm trying to hide columns based on user input in DDD format, for example typing in 'Sun' into cells(5,3).

It looks along the top row of the workbook and is meant to hide cells without this user input (for example any 'Fri').

The top row of cells are formula'd to text based on a date e.g. = TEXT(WEEKDAY('CELL WITH DATE IN'), "DDD").

However it doesnt seem to work and I dont know why!

If anyone can enlighten me I would greatly appreciate it!


Regards,


Coeus.

Please Login or Register  to view this content.