Academic Year calculator

[sedonovan]

Hi all,
I wonder if you could help?

I'm looking for a way of working this out in Excel

if todays date is, or before, 31/08/YYXX - the Year Displayed should be
YYXX-1/XX

eg. if its
3rd october 2004 - it should display 2004/05
3rd July 2005 - it should display 2004/05


if todays date is, or later than, 01/09/YYXX - the year displayed
should be YYXX/XX+1

eg if its

3rd september 2005 - it should display 2005/06
3 january 2006 - it should display 2005/06.

Any ideas??
Thanks

 

[David Biddulph]

Hi all,
I wonder if you could help?

I'm looking for a way of working this out in Excel

if todays date is, or before, 31/08/YYXX - the Year Displayed should be
YYXX-1/XX

eg. if its
3rd october 2004 - it should display 2004/05
3rd July 2005 - it should display 2004/05


if todays date is, or later than, 01/09/YYXX - the year displayed
should be YYXX/XX+1

eg if its

3rd september 2005 - it should display 2005/06
3 january 2006 - it should display 2005/06.

Any ideas??

=IF(MONTH(TODAY())<9,YEAR(TODAY())-1&"/"&RIGHT(YEAR(TODAY()),2),YEAR(TODAY())&"/"&RIGHT(YEAR(TODAY())+1,2))

 

[sedonovan]

Thanks, that's perfect!