Vlookups and dates

[Bonnie]

I am having trouble pulling over dates in the format of
29-Mar. When it comes over it looks like this 36613 and
then if I try and format it to look 29-Mar it comes over
with the wrong date. I've tried formating it 00/00/00 and
so on. Nothing matches the orginal date.

Help please!

B.

 

[Frank Kabel]

Hi Bonnie
apply a date format to this cell in the format dialog or choose a
customer format like
dd-mmm

 

[Norman Harker]

Hi Bonnie!

You have the default date serial number scheme as the 1904 date
system.

Use:

Tools > Options > Calculation
Remove check from 1904 Date system
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Phillips]

Dates are held as a serial number since 1st Jan 1900, and you are seeing
that number.

Format it as dd/mm/yy or mm/dd/yy if US style.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

add 1462 days to your date (put 1462 in an empty cell, copy it, select
the import and do edit>paste special and select add)
Or change the date system, you are using Mac's default date system under
tools>options>edit 1904 date system
It means that a workbook with dates created with the default excel for
windows system will come out as
date-1462 and vice versa. So you can either change your system or add 1462
days to the dates