Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate current school year from DOB ongoing?
From a list of dates of birth I need to show what school year they are in
today, but have it so it is always correct in the future too. I can caculate their current school year using a vlookup table of dates of birth between Sept and August and the relevent school year, but come September 2009 this will be wrong. i.e. if born 30th January 1996 today you will be in school year 8. If I check the spreadsheet in January 2010 I need it to be telling me you are now in year 9. School year runs from 1st September to 31st August. Any help much appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Days Left in Current Year | Excel Worksheet Functions | |||
Formula to calculate the current year | Excel Discussion (Misc queries) | |||
calculate prior calendar year end from a moving current date | Excel Worksheet Functions | |||
School year repetitive listing | Excel Discussion (Misc queries) | |||
Formula for year in school? Freshman, Sophmore | Excel Worksheet Functions |