DATEVALUE

  • Thread starter Thread starter Claire
  • Start date Start date
C

Claire

Hi

This may seem like a really daft question but does the
DATEVALUE function work differently in the US to France?
If it does how would I go about changing a formula from
France to make something work.

Any help/tips/hints gratefully received
 
One possible source of error is that time zero can be
changed. Make sure that the correct reference date is
selected in:
TOOLS | OPTIONS | INTERNATIONAL
That date can be Jan 1 1900 or Jan 1 1904
 
it's in Excel ... 2002 in MY case.
But, to find out the date in YOUR worksheets vs the dates
in the French worksheet simply write
today's date in each and copy to another cell using
EDIT | COPY | PASTE SPECIAL | VALUE
for each one.
If the values are equal then they're both set the same.
If they're not then subtracting the two and dividing by
365 should give you (approximately) 4 since they'll be
different by 4 years. (1900 vs 1904).
Once you know they're different you'll know how to deal
with them.
 
thanks I shall give this a go...I'm using either Excel
2000 or Excel 2003 and this particular problem has been
driving my crazy all year!
 
One more thing to watch out for is ambiguous dates:

=DATEVALUE("08/12/2003")

Is this December 12, 2003 or August 12, 2003?

You might want to look at converting your =datevalue()'s to =date(yyyy,mm,dd) to
remove any ambiguity.
 
Back
Top