Home » Forums » Open Source Learning Center » Question and Answer

Show a member a year after they joined

Submitted by Mastergas on 10 March, 2016 - 00:16

I am a secretary of a new club. I posted everyone who has joined over the year. It time for them to renew there membership.
How can I have excel find them for me. I am sure it is quit simple
Excel 2003 Windows 7
Thank you for your help

‹ Date count error drop down list that will fill and additonal cell ›
»

time to renew

Submitted by Swetha on 9 November, 2016 - 10:55.

=IF((NOW()-I10)>=365,"Time to Renew your memebership")

text I10 in formula will be your date of joining.

»