dates

  • Thread starter Thread starter mikey
  • Start date Start date
M

mikey

I am working depreciation rates , it requires to calculate the numbe
of days between The date of purchase ie, 09/07/2003 and year endin
31/03/2003 with year as 365 days . There are hundreds of entries
 
Hi Mikey!

Where B1 is the later date and A1 the earlier date, the number of days
between them is:

=B1-A1
Format General

Dates in Excel are serial numbers representing the number of days from
31-Dec-1899.
 
Thanks for the help ,


start date 01/04/2004
end date 31/03/2004
how do i show all days of the months that have 31 days are counte
and shown as 31 days and not 30 days without have to add days to th
formual ,
while doing so for a single month is fine but doing it for the whol
year seems
to long drawn as there are several hundred entries . ie, Jan to Dec
has 7 months of 31 days and feb has 28 days and the other months as 3
days all add up to 365 days
 
Hi Mikey,
Reread Norman's reply. Converting a serial number back to
a date format is done in Excel. Dates are stored as numbers
from Dec 31, 1899 not as components as you write them.
As long as you are in a range from March 1, 1900 thereafter
you will have not problem.

If you want to see what Excel actually used for a date look at:
A1: 01/04/2004 B1: =A1 (format as #) displays 38078
A2: 31/03/2004 B2: =A2 (format as #) displays 38077

Time is stored as fractional dates. 38078.5 would be noon April 1st, 2004.

More information on Date and Time
http://www.mvps.org/dmcritchie/excel/datetime.htm

One of the serious drawbacks of some older mainframe programs was
that every programmer had to write their own date routines because
they were not supplied with compilers. This is not the case for working
with PC applications -- it is builtin.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top