S
STEDIX
I am trying to develop a formula that would look at a date and return a value
based on that date.
For example, if the date was 4/15/09, it would return a value "FY2010 1st"
So the forumula would have to look at the date and based on a date range
return a value. I would want to have 4 quarters with a corresponding date
range. eg, 8/1/09 would return a value "FY2010 2nd" and so on.
I appreciate any help I can get.
based on that date.
For example, if the date was 4/15/09, it would return a value "FY2010 1st"
So the forumula would have to look at the date and based on a date range
return a value. I would want to have 4 quarters with a corresponding date
range. eg, 8/1/09 would return a value "FY2010 2nd" and so on.
I appreciate any help I can get.