Here is my issue:
- I have two date fields "to" and "from". I want the formula to recognize the fiscal year in the fields and have a specific output. Example
from = 1990-05-03 to= 1991-02-29
output = $319
I'm not counting the number of days, just the fiscal year. Different fiscal years will have different outputs. For 1991-1992 the output will be $732
The to - from dates entered will always be in the same fiscal year so the formula will not have to try and split years.
I guess it would be an IF statement to read if date is more than 1990-03-31 AND less than 1991-04-01 output = $301 and I would do one for every year up to 2005.
Any insight would be great! I am using excel V10 (2002) if it matters.
Thanks,
Aaron
- I have two date fields "to" and "from". I want the formula to recognize the fiscal year in the fields and have a specific output. Example
from = 1990-05-03 to= 1991-02-29
output = $319
I'm not counting the number of days, just the fiscal year. Different fiscal years will have different outputs. For 1991-1992 the output will be $732
The to - from dates entered will always be in the same fiscal year so the formula will not have to try and split years.
I guess it would be an IF statement to read if date is more than 1990-03-31 AND less than 1991-04-01 output = $301 and I would do one for every year up to 2005.
Any insight would be great! I am using excel V10 (2002) if it matters.
Thanks,
Aaron