View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DSCAVOTTO
 
Posts: n/a
Default Lookup dates, fiscal period table

I am trying to create a lookup table to determine the fiscal period of a
transaction. For example,a transaction dated Feb. 21, 2006 would be in period
14 in a table that started with Jan 2005. The file I am working with is
fairly substantial with numerous transactions every month. I will need to
have at least a three year table.

Period Month
1 Jan-05
2 Feb-05
3 Mar-05
13 Jan-06
14 Feb-06

Thanks for your help.
--
Dave