View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PK PK is offline
external usenet poster
 
Posts: 69
Default referencing dates

I have a number of dated enteries in a spreadsheet. As our Financial year
starts April 1st and ends March 31st following year I would like to reference
the enteries by financial year.

Fianancial I have dates in column A and would like to reference them by
financial year in column B

A B
21/04/06 06/07
17/10/05 05/06
13/08/06 06/07
17/03/06 05/06

Is this possible
--
pk