Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for year in school? Freshman, Sophmore
I volunteer with a youth group on the weeknds. I need to create a
spreadsheet that will track their grade level in school. (Freshman, Sophmore etc.) Is there a formula I can use that will help me with this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for year in school? Freshman, Sophmore
What will determine the year? Is it age, birthdate, or what?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "bob the bolder" <bob the wrote in message ... I volunteer with a youth group on the weeknds. I need to create a spreadsheet that will track their grade level in school. (Freshman, Sophmore etc.) Is there a formula I can use that will help me with this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for year in school? Freshman, Sophmore
If I could use a birthdate as the determiner taht would be great.
"Bernard Liengme" wrote: What will determine the year? Is it age, birthdate, or what? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "bob the bolder" <bob the wrote in message ... I volunteer with a youth group on the weeknds. I need to create a spreadsheet that will track their grade level in school. (Freshman, Sophmore etc.) Is there a formula I can use that will help me with this? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for year in school? Freshman, Sophmore
Bob,
With their birthday in cell A1, try: =CHOOSE(DATEDIF(A1,DATE(2006,11,30),"y")-14,"Freshman","Sophomore","Junior","Senior") this assumes that Dec 1 is the break date for deciding which class a child is in... HTH, Bernie MS Excel MVP "bob the bolder" <bob the wrote in message ... I volunteer with a youth group on the weeknds. I need to create a spreadsheet that will track their grade level in school. (Freshman, Sophmore etc.) Is there a formula I can use that will help me with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |