Help with formula

[jordanburch]

hey I have the following.

=+IF(OR(A8="SEPTEMBER","AUGUST","JULY"),CONCATENATE(LEFT(A9,3)-1,"-",TEXT(EDATE(DATEVALUE("01-"&A7),-2),"MMM"),RIGHT(A9,2)))

i cant get it to work right for some reason. any help is appreciated! I get the below error.

Jordan

a value used in the formula is the wrong data type.

 

[Joe4]

This part is incorrect:

OR(A8="SEPTEMBER","AUGUST","JULY")

as with OR and AND, each condition needs to be declared explicitly.

So it should be:

OR(A8="SEPTEMBER",A8="AUGUST",A8="JULY")

I cannot really speak to the rest, as you have not shown us your data.
If you still have issue, show us examples of what is in cells A7, A8, and A9 and show us your expected output.

 

[jordanburch]

This part is incorrect:

OR(A8="SEPTEMBER","AUGUST","JULY")

as with OR and AND, each condition needs to be declared explicitly.

So it should be:

OR(A8="SEPTEMBER",A8="AUGUST",A8="JULY")

I cannot really speak to the rest, as you have not shown us your data.
If you still have issue, show us examples of what is in cells A7, A8, and A9 and show us your expected output.

thanks Joe Worked!

 

[Joe4]

You are welcome.