Fiscal Month Formula
Maybe you can enlighten us what numbers you are using, don't assume that
everyone knows what a fiscal month cover. If you had posted all the
necessary numbers with their respective month I would have given you a
formula now I can only assume
=IF(T2="","",VLOOKUP(T2,{0,"Jan";5,"Feb";8,"Mar"}, 2))
will work for Jan and Feb and you can use the same method to extend it
--
Regards,
Peo Sjoblom
"Marilyn" wrote in message
...
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
|