Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Conditional formatting on anniversary

19 views
Skip to first unread message

Garrett Oler

unread,
May 19, 2022, 9:22:11 PM5/19/22
to
Hi

I am at a loss for how to make this work.

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.

Any ideas?
Thanks,
Garrett

Claus Busch

unread,
May 20, 2022, 5:22:07 AM5/20/22
to
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.
--
Windows10
Microsoft 365 for business

Michael Soyka

unread,
May 20, 2022, 1:09:37 PM5/20/22
to
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.

Michael Soyka

unread,
May 20, 2022, 1:27:17 PM5/20/22
to
Actually, that doesn't work if the start date is in January. Modulo
arithmetic is required:

=MOD(MONTH(A1)+11-MONTH(TODAY()),12)=0
0 new messages