L
LinLin
Hi Everyone
I have month columns with labels which start with April 2009 through March
2010.
I have another cell which indicates the current month.
If the current month is December,
I need a formula which looks at my columns and tells me that April to
December is 8 months.
If I am in January however, I need the formula to calculate 9 months.
(Most of the date functions obviously assume your first month is January (1)
and last month is December (12))
(Or if it doesn't look at the columns, that's fine too, but I figure that
will help somehow).
I am trying to create an average function but it’s a bit trickier than I
anticipated!
I have tried some If formulas but it’s a bit beyond me.
Hope I've explained that OK - happy new year to all!
I have month columns with labels which start with April 2009 through March
2010.
I have another cell which indicates the current month.
If the current month is December,
I need a formula which looks at my columns and tells me that April to
December is 8 months.
If I am in January however, I need the formula to calculate 9 months.
(Most of the date functions obviously assume your first month is January (1)
and last month is December (12))
(Or if it doesn't look at the columns, that's fine too, but I figure that
will help somehow).
I am trying to create an average function but it’s a bit trickier than I
anticipated!
I have tried some If formulas but it’s a bit beyond me.
Hope I've explained that OK - happy new year to all!