Calculate column in list depending on Date

[2ks]

I am struggling to find a code to calculate the financial year depending on the DATE input by user in DATE field.

Basically if a user selects date 29/1/2010 from the DATE column in the year column I want it to auto return 2009/10 in the Year Column.

If the date is 29/1/2011 it needs to return 2010/11 and so on

Thanks

 

[dinger2121]

If it based upon the year, you can do something like this -

=IF(TEXT(date,"YYYY")="2009","2009",IF(TEXT(date,"YYYY")="2010","2010","2011"))

and just continue it for different years.

carl
MCSD, MCTS:MOSS