Calculate End Date

[jbuck88]

Hi, just acquired a large database for a charity I volunteer for, trying to get to grips with it. We take kids on holiday up until they're 13; I have a list of DOBs.

What I need to do is generate the last year (in practice, the last July) in which we take each child on holiday.

If the child's DOB is prior to July 20th, I need to add 13 years to their DOB year to generate their last year on a project.

If their DOB is after July 20th, I need to add 14 years to their DOB year to generate their last year on a project.

My DOB's are currently formatted as dd/mm/yyyy (let's call that column A) but obviously that can easily be changed. I have already got yyyy (B) and dd/mm (C) if that is helpful!

Obviously I could do this by hand, but we have about 500 kids on record so it'd be a bit time consuming. Any help would be very much appreciated!

Thanks a lot,

John

[DonkeyOte]

John, welcome to the board - in truth your thread title falls foul of Forum Rule 1
Given this first post etc I have modified for you on this occasion - going forward please be sure to title based on the specifics of the problem: Calculating End Date

Please Login or Register  to view this content.

[jbuck88]

I do apologise.

Many thanks for that answer!