2003 from 2010 IF statements

[willRM]

I have worked on my home laptop and used the following statement: =IF(AND(MONTH(B42)=MONTH(TODAY());DAY(TODAY())-DAY(B42)<1);"Birthday";"No")

This is on 2010 and works, however the same on 2003 gives me an error.

any help?

 

[Weazel]

just a thought but what are the regional settings on the 2003 machine?

you could try replacing the semicolons with colons to see if that works

=IF(AND(MONTH(B42)=MONTH(TODAY()),DAY(TODAY())-DAY(B42)<1),"Birthday","No")

 

[willRM]

just a thought but what are the regional settings on the 2003 machine?

you could try replacing the semicolons with colons to see if that works

=IF(AND(MONTH(B42)=MONTH(TODAY()),DAY(TODAY())-DAY(B42)<1),"Birthday","No")

Yes i have replaced them. Still gives me this isssue? Sorry what do you mean with regional settings?

 

[Weazel]

the regional settings in the Windows control panel....
different countries have different regional settings that affect how Excel functions

What is the specific error you are getting in Excel with the formula?

 

[willRM]

i cant recall. it is te general one that says it doesn't work then suggests to try and not use = or - etc

 

[JoeMo]

Yes i have replaced them. Still gives me this isssue? Sorry what do you mean with regional settings?

What's in cell B42 on the 2003 machine?

 

[willRM]

it is a date exp: 12/06/15

 

[JoeMo]

it is a date exp: 12/06/15

Does your formula in the 2003 machine return an error in the cell like #VALUE! or #N/A? If yes, is B42 text? In some empty cell enter =ISNUMBER(B42) what do you get?

 

[willRM]

Does your formula in the 2003 machine return an error in the cell like #VALUE! or #N/A? If yes, is B42 text? In some empty cell enter =ISNUMBER(B42) what do you get?

I did the ISNUMBER: gave me a ''TRUE'' return.

I have gone through the method again. seems to be working now. another question: If I want to imply that as a condiotnal format, i understand it gets typed in differently?

 

[willRM]

Does your formula in the 2003 machine return an error in the cell like #VALUE! or #N/A? If yes, is B42 text? In some empty cell enter =ISNUMBER(B42) what do you get?

i am trying to get age using the following : =DATEDIF(K7,today(),''Y'')

it gives me this error: The formula you have typed contains an error???