• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chandoo's Birthday Template

K

Kenny9002

New Member
Chandoo's brilliant Birthday template is designed to remind one of birthdays in one's contact list where the birthday is 'today'. I need help to tweak the formula in the template so that I should be reminded of each contact's birthday say 5 days or 6 days before the actual birthday, instead of 'today' the actual date of the birthday.

I would appreciate some help with this, please.

Thanks.

Kenny9002
 
Hi Narayan,

Thanks for your kind response. I have not yet got a workbook. I just followed Chandoo's Birthday Reminder video which is very brilliant in demonstrating how this could be done. However, in his video demonstration, he showed (with formula) how someone's birthday could be highlighted - using excel - on the exact birthday.

However, I was asking for help with a tweak of the formula which Chandoo provided that will enable a reminder of the birthdate to come up e.g. 3 or 4 days before the actual birthday instead of the reminder coming up on the same day of the birthday.

Here is the link of the video, please:

http://chandoo.org/wp/2010/10/26/birthday-reminder-template/

Thanks for your anticipated help.

Kenny9002
 
You must log in or register to reply here.
Back
Top