View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marilyn Marilyn is offline
external usenet poster
 
Posts: 211
Default Fiscal Month Formula

Hello
I NEED FISCAL Month
I used the weeknum function to determine the week number of the date in
column T
I added a column at the end labeled 'fiscal month'
and I used this formula
=IF(T2<5,"Jan",IF(T2<8,"Feb")) but I cannot fit all 12 months in this
formula.
What formula can I use to determine the fiscal month , I need to use all 12
month from Jan to Dec., or Is there another way to do this?
Thanks in Advance