Tip:
Highlight text to annotate it
X
for those who want to
download the worksheet in these next examples
go to thefrugalcomputerguy.com video tutorials
and office spreadsheet and down at the bottom that page
I will put the link to download the .ods spreadsheets
now we want to add a
birthdate for each have our made up
people here and sense they're made up people we're going to make up a birthday
but before we do that let's take a look at how
the date function works so I'm going to type in
=today()
and there's
today's date 8/4 and if I
go on here and reformat that to
a number we see
40759 what that, more or less is,
is the number of days since 1900 let's take a look at that
in a little more detail I have created this
date and time sheet to explain how the dates work
up at the top in our first example
I show the date of today
40,759 so it's been forty thousand seven hundred and fifty nine days
since 1900 now if I reformat that as a date
only we see this 8/4/2011
when I have the date and time
we have midnight basically because was see that as time only
so it's all equal to the same thing C5 this is equal to
C3 and then I just point to the one above it in this example
now coming down for the next example
I'm using today's date I'm also using 0
to show that it 0 is 12 30 1899
and 1 is = 12/31 this is what I
used when I did the format as the dash one two three four
and my date format date and time
to and those are what I selected in the formant and here we're seeing the same
thing more or less
zeros midnight
when I come down here we see a decimal point dot 45 and that is telling us
that it's
1048 a.m. so when we're ending the time we just
adding a decimal point and to get 12:30
I get this dot 52083333
and that was not randomly selected I went through and
typed in 12:30 then I got the number version
and that's how I put that in there and using the one for the 1899
two for 1/1/1900 so we can see how to
add and subtract dates if you want to know something a week away
you would add seven subtract seven and we can tell the number of days between
dates by using numbers... and times if you are using times
4:30 a.m. 10:30 p.m. on
the next day to get the number of hours that would all be done
with the decimals so that's how the dates work - and I will put this out
on website if you want down this and play with it a little all
all cool