Insert the information required in the PINK cells in each case.
So, how old are you? What day will it be?
Today's Date: To this date:
My Birth Date:
If I add… Years
Years Old 0.00 Months
Months Old 0.00 Days
Days Old 0
Hours Old 0 Then it will be:
Minutes Old 0
Seconds Old 0
Questions for you to consider:
1. Enter =TODAY() in the Today's Date box. What happens?
2. Enter a birth date. When are you 1million seconds old?
3. How are the values in the green cells are calculated?
4. What date is in 6 years, 6 months and 6 days from today?
5. Look at the formula in cell H11. Explain how it works.
=DATE(YEAR($H$5)+$G$7,MONTH($H$5)+$G$8,DAY($H$5)+$G$9)
6. How would the formula change if you wanted to find
earlier dates? Insert a new worksheet and try it yourself.
Insert the information required in the PINK cells in each case.
Time Difference Adding times Questions for you to
Directions: Enter the times in Directions: Enter the times in 1. Enter an important future date a
HH:MM (Using 24hr time code) HH:MM:SS Can you explain why this also wo
2. Enter a selection of start and end
Start time: 10:00 AM Time A: 13:21:00 Notice how the time shows as AM
End time: 5:30 PM Time B: 112:22:22 3. How could you allow for time zon
7:30 125:43:22 4. Enter times A and B and check if t
How would you add more times.?
My important date is: 12/25/2009 5. On that new worksheet, investiga
There are -697 days until that day. Experiment by changing the cell f
Questions for you to consider:
1. Enter an important future date and see how many days to go.
Can you explain why this also works for past dates ?
2. Enter a selection of start and end times. [Use 24hr time format]
Notice how the time shows as AM or PM. How does this work?
3. How could you allow for time zones? Try it on your new worksheet .
4. Enter times A and B and check if the sum is correct.
How would you add more times.? Try it on your new worksheet.
5. On that new worksheet, investigate the =NOW() formula.
Experiment by changing the cell format to date or time .