Thread: How do I get Excel to display which financial year a date is in?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LemLems LemLems is offline
external usenet poster
  
Posts: 2
Default How do I get Excel to display which financial year a date is in?
Hi
I have a list of dates in an Excel 2000 spreadsheet. I'm looking for a
function that will display which financial year those dates fall in. So for
example if the date was 31/01/2009 I would want it to show 08-09.
Does anyone know of a function that would do this?
thanks
Reply With QuoteReply With Quote