Hi there,

I was looking for a way to hightlight the current week on an Excel worksheet based on today's date and I found a post here which described the formula:

=A2-WEEKDAY(A2)=TODAY()=WEEKDAY(TODAY()))

It does work ok, however it considers the week as starting on a Sunday. How can I get this formula to recognized my week as starting on TUESDAY instead?

I've tried different things and I've checked the WEEKDAY syntax* but I'm unable to get it work. Its always defaults to Sunday. I cannot even get it to start the week even on Monday.

* http://www.bettersolutions.com/exce...QD747050501.htm

Thank you in advance!

jfjunior

http://www.pcreview.co.uk/forums/ne...newthread&f=30#