Calculation Using MONTH

[Evan]

I need to multiply an amount by the current month less 6 (ie July
would return a value of 1 rather than 7). I want to use the MONTH
function to do this. I have tried MONTH(A1-6) and (MONTH(A1)-6), but
both return "January 09". Is it even possible to perform a
calculation using MONTH? The reason I want to use MONTH is because I
create a monthly spreadsheet and it's easier to have a formula set up
like this. If I can't use MONTH is there an alternative approach?

 

[Bob Greenblatt]

I need to multiply an amount by the current month less 6 (ie July
would return a value of 1 rather than 7). I want to use the MONTH
function to do this. I have tried MONTH(A1-6) and (MONTH(A1)-6), but
both return "January 09". Is it even possible to perform a
calculation using MONTH? The reason I want to use MONTH is because I
create a monthly spreadsheet and it's easier to have a formula set up
like this. If I can't use MONTH is there an alternative approach?

What you want is Month(a1)-6. This will return an integer, which may be
negative if the date is prior to June 1. The reason you're getting the
"funny" answer is the format of the result cell.