Vlookups and dates

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

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.
 
Hi Bonnie
apply a date format to this cell in the format dialog or choose a
customer format like
dd-mmm
 
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.
 
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)
 
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
 
Back
Top