Academic Year calculator
 

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?? :confused:
Thanks


--
sedonovan
------------------------------------------------------------------------
sedonovan's Profile: http://www.excelforum.com/member.php...o&userid=35626
View this thread: http://www.excelforum.com/showthread...hreadid=554065

Academic Year calculator
 

"sedonovan" wrote
in message ...

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?? :confused:

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

Academic Year calculator
 

Thanks, that's perfect! :)


--
sedonovan
------------------------------------------------------------------------
sedonovan's Profile: http://www.excelforum.com/member.php...o&userid=35626
View this thread: http://www.excelforum.com/showthread...hreadid=554065