Hi Everyone

I am wanting to read a set of students birthdays, calculate the current age and place it in a cell that represents a specific day in a specific week. i.e. I have a sheet that has a term with 10 rows representing 10 weeks of the 2014 calendar. Each week includes weekends. I can calculate the current age, but getting Excel to search for the birthday and place the age in is another matter!

Hi

You need to start your code from the list of birthdays as weeks..So you can split the birthday to 52 weeks

Datediff function would provide you.the date difference between the birthday and reference day, say 1st Jan In days

You can use the Mod function to get the week by dividing by 7

Now based on the week.number you can place it in appropriate cells

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi

Thanks for this. I have been using Datediff to find current age, but it still evades me as to get it to step through a calendar and find a specific date such as the date a student turns 12. Does it print the cumulative age in each cell? i.e. I have 52 weekly dates then I search for the one that is when the student turns 12? I think I would like a piece of code for this!

Many thanks

Can you make a Calendar in one row and 52 columns? i.e. each student would have a row containing their name and birthday followed by 52 columns on of which contains the twelfth birthday would be highlighted.

Ian