date error

[Oyster1967]

Hi guys,
I have recently changed to 07 and previously I had made a timesheet where people insert the first date (16/5/2011) and then the formula auto fills the rest.
BUT NOW
when I insert the formula it returns a value error. It doesn't happen on other 07 computers just mione and some others.
Any trouble shooting tips.

<TABLE style="WIDTH: 1736pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=2314><COLGROUP><COL style="WIDTH: 429pt" width=572><COL style="WIDTH: 437pt; mso-width-source: userset; mso-width-alt: 10642" width=582><COL style="WIDTH: 435pt; mso-width-source: userset; mso-width-alt: 10605" span=2 width=580><TBODY><TR style="HEIGHT: 31.5pt" height=42><TD style="BORDER-BOTTOM: red 1.5pt solid; BORDER-LEFT: red 1.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 429pt; HEIGHT: 31.5pt; BORDER-TOP: red 1.5pt solid; BORDER-RIGHT: red 1.5pt solid" class=xl69 height=42 width=572>40679</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 437pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=582>=IF(B11,B11+1," ")</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 435pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=580>=IF(B11,B11+2, " ")</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 435pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=580>=IF(B11,B11+3, " ")</TD></TR></TBODY></TABLE>

<TABLE style="WIDTH: 1086pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1446><COLGROUP><COL style="WIDTH: 215pt" width=286><COL style="WIDTH: 218pt; mso-width-source: userset; mso-width-alt: 10642" width=291><COL style="WIDTH: 218pt; mso-width-source: userset; mso-width-alt: 10605" span=2 width=290><COL style="WIDTH: 217pt; mso-width-source: userset; mso-width-alt: 10569" width=289><TBODY><TR style="HEIGHT: 31.5pt" height=42><TD style="BORDER-BOTTOM: red 1.5pt solid; BORDER-LEFT: red 1.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 215pt; HEIGHT: 31.5pt; BORDER-TOP: red 1.5pt solid; BORDER-RIGHT: red 1.5pt solid" class=xl69 height=42 width=286>16/5/2011</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 218pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=291>17/5/2011</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 218pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=290>18/5/2011</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 218pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=290>19/5/2011</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 217pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=289>20/5/2011</TD></TR></TBODY></TABLE>

 

[Ruddles]

What are you showing us, the sheet that works or the sheet that doesn't work? Which cell is B11 and which cell is giving the #VALUE! error?

 

[Oyster1967]

Thanks for your reply, I have (since posting the question) realised the problem. Our company has hundreds of computers and some were formated with American dates, therefore if the day was greater than 12, it would switch to the month and return an error because there is no 13th or 23rd etc month.
We have since re-formatted all computers to be the one true and real date, being the Aussie one!! lol
Thanks for your responce. Cheers