You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Actually, that doesn't work if the start date is in January. Modulo
arithmetic is required: