Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing a different tab by referencing a list in the current s | Excel Worksheet Functions | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |