On 05/20/2022 5:22 AM, Claus Busch wrote:
Hi Garrett,
Am Thu, 19 May 2022 18:22:09 -0700 (PDT) schrieb Garrett Oler:
I have a cell with the date of the start of a service subscription.
I want to highlight a cell every 11th month so they are reminded that the subscription will renew on the next month. I have figured out how to make it work once, but not repeatable year over year.
try:
=MONTH(A1)=MONTH(TODAY())-1
Regards
Claus B.
Assuming the start date is in A1, shouldn't it be:
=MONTH(A1)-1=MONTH(TODAY())
instead?
For example, if the start date is in May, the reminder should always go
out in April, assuming I understand the OP's desire.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)