View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin_London
 
Posts: n/a
Default year function and financial years

In the UK our financial year runs April to March. Is there any way of using
the =year() function on a date so that it runs on these dates rather than
calender years? Basically I need Jan, Feb and March of next year to be
recognised as the same year as April to December of this year.