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/excel/EDH113/QD747050501.htm
Thank you in advance!
jfjunior
https://www.pcreview.co.uk/forums/newthread.php?do=newthread&f=30#
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/excel/EDH113/QD747050501.htm
Thank you in advance!
jfjunior
https://www.pcreview.co.uk/forums/newthread.php?do=newthread&f=30#