Third, she wants to see a status of "expired" for any memberships already expired, and "expiring soon" for any memberships expiring in the next 30 days.įinally, she said it would be nice to see "expired" members highlighted in pink, and those "expiring soon" highlighted in yellow.Īlso, can she have it before her lunch meeting at noon?įirst, let's convert this data to a proper Excel Table. Second, she wants to see how many days remain before expiration. She's given you a list of 1,000 people that have renewed a membership in the last year or so, and she's looking for several things.įirst, she wants you to calculate an expiration date one year in the future, on the last day of the same month that membership was last renewed. Let's say your company has started a membership program of some kind and your boss just sent you a set of data. In this video we'll look at how to calculate and highlight expiration dates.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |