Hi all,
I currently use the following formula in Conditional Formatting to highlight a persons birthday:
=$R1=DATE(YEAR($R1),MONTH(TODAY()),DAY(TODAY()))
which changes the colour of the cell on their birthday.
However, I need to amend this formula so that the highlighting applies to the current week, as in Sunday thru to Saturday.
My amendments have not been successful and you cannot use the WEEKNUM function in conditional formatting for some reason!
Any suggestions ...spellbound
Bookmarks