Formula Problem #value!

Topic

New Reply

I have the following formula in cell J1 on sheet TB Consolidation

=IF(DATE(“20″&MID(F3,4,2),MID(F3,7,2),28)>DATE(“20″&MID(I3,4,2),MID(I3,7,2),28),”Y”,IF(DATE(“20″&MID(F3,4,2),MID(F3,7,2),28)=DATE(“20″&MID(I3,4,2),MID(I3,7,2),28),”CURR”,”N/A”))

It gives the result #value!. I think that I need to include a text function within the above formula, but I not sure how to incorporate this within another formula in order for the error to be rectified

I have also attached some text data referring to the respective cell numbers

Your assistance will be most appreciated

Reply | Quote

Replies

Cell F3 contains “40542 YTD”, so using MID(F3,7,2) to give the Month value of your first date, results in “YT”.
Similarly, I3 contains “40544 YTD”, so you’re getting “YT” as the Month part for the second date in your IF statement.

Reply | Quote

Thanks for the help, much appreciated

Reply | Quote

It’s worth noting that if you click on the ‘fx’ or ‘=’ icon just to the left of the formula edit bar it’ll give you a breakdown of what the formula does. Then, if you click on each of the functions within the formula it’ll tell you what’s happening with each
.27573-Function

Reply | Quote