Correcting #value! Problem

[howard]

I have the following formula in cell J1

=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

Management Accounts.xls
	F	G	H	I	J
1	15/03/2011		*CHKCLUMN*	24/02/2011	#VALUE!
2
3	Feb2011YTD	MTD	A/CNOTONTB/PULL/BOTH?	Feb2011YTD	P/MNTHADJ?
TB CONSOLIDATION

 

[matthewjapp]

Use

=if(iserror(.......,"Whatever",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"))

 

[UniMord]

Use Evaluate Formula to see where the error is. It appears your problem is in the values entered in the Date function.

 

[howard]

Hi Guys

Thanks for the help