This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Monday January 29 2024
Tuesday February 27 2024
Tuesday March 26 2024
Friday April 26 2024
Wednesday May 29 2024
Wednesday June 26 2024
Saturday July 27 2024
Wednesday August 28 2024
Wednesday September 25 2024
Tuesday October 29 2024
Wednesday November 27 2024
Friday December 27 2024
Monday January 29 2024 =A4
This formula works. However, I would like to tweak the formula a bit to go to the next month following last pay date. So I tried replacing the formula MONTH(A3)=MONTH(TODAY()) with: =XLOOKUP(TODAY(List!A4:A15,List!A4:A15,"",1) and it didn’t work. Can you help me?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
OK, I got what you meant now.
Here is the formula solution
=XLOOKUP(TODAY(),$A$4:$A$15,$A$4:$A$15,,1)=$A4
I hope this helps you
Regards
Jeovany
I meant A4 vice A3 in my initial formula. MONTH(A4)=MONTH(TODAY())
Hi there
Re, "... to go to the next month following last pay date"
Please try the formula =MONTH(A4)=MONTH(TODAY())+1
I hope this helps you and gives a solution to your problem
Regards
Jeovany
=MONTH(A4)=MONTH(TODAY())+1 didn't work. A4:A15 are the paid dates above. In C2 I have the formula: =XLOOKUP(TODAY(), List! A4:A15, List! A4:A15, "", 1) Which is the date that I am looking for. (Which is Tuesday 29 October 2024). Currently I am using the formula: =MONTH(A4)=MONTH(TODAY()) which works up until Wednesday September 25 2024, but then keeps being highlighted until the 01 October 2024. After Wednesday September 25 2024 I would like Tuesday 29 October 2024 Highlighted.
Thank-you it worked. but can it also work in two columns with January to June in column A and July to December in column B in order to reduce the amount of space in a single column on a page?