Change a value if date changes

[sadsfan]

I have a spreadsheet that I use with my students in school. There is a column which shows which year group they are in (numbered from 1-6). Every September this increases by 1, i.e. from year 1 to year 2 etc. Is there a formula that will automatically change this for me, or do I need to write some VBA code to do this?
Thanks

 

[BAlGaInTl]

I have a spreadsheet that I use with my students in school. There is a column which shows which year group they are in (numbered from 1-6). Every September this increases by 1, i.e. from year 1 to year 2 etc. Is there a formula that will automatically change this for me, or do I need to write some VBA code to do this?
Thanks

It is possible that you could come up with a formula to figure this out. You would need to have the year or date that a student started to get it. Do you have that information available?

Can you provide a sampling of your data?

 

[lenze]

No need for a formula. Simply enter a 1 in a blank cell and copy. Then select your column and choose Edit>Paste Special>Add>OK. You're done!!
lenze
PS: You can delete the 1.

 

[sadsfan]

Yes I have a start date column, it is in mm/yyyy format. Would I need a nested 'if' statement?

 

[sadsfan]

No need for a formula. Simply enter a 1 in a blank cell and copy. Then select your column and choose Edit>Paste Special>Add>OK. You're done!!
lenze
PS: You can delete the 1. You may also have to reformat your cells to date

Mind you this sounds a lot easier! Thanx lenze

 

[BAlGaInTl]

lenze's solution will work and will need to be repeated each year.

Here is the formula solution that I came up with:

=IF(MONTH(TODAY())<9,YEAR(TODAY())-YEAR(C2),YEAR(TODAY())-YEAR(C2)+1)

Book1
	A	B	C	D
1	Last	First	StartDate	YearGroup
2	Doe	Jane	9/2007	2
3	Smith	John	9/2008	1
4	Taylor	James	9/2005	4
Sheet2

 

[sadsfan]

Thanks BAlGaInTl, that will do nicely!

 

[scottylad2]

Excel Workbook
	A	B	C	D	E
1	Year 1	Year 2	Year 3	Year 4	Year 5
2	08 2007	07 2008	07 2009	07 2010	07 2011
Sheet5

Crude but simple lol

 

[scottylad2]

The formula above can just be start date in column A then in B and drag along or enter in non contiguous cells , =A+365 formatted as mm yyyy