Scribd
Upload
10 views6 pages

Excel Date and Time Functions Guide

The document outlines a series of instructions for using formulas in a spreadsheet to calculate various date-related information, including the day of the week for dates in column A and the current date and time. It also includes calculations for future and past dates, as well as a program completion timeline based on workout sessions. The document provides a structured format for organizing this data, including instructor names and workout types.

Uploaded by

jjbhzdc86n
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
10 views6 pages

Excel Date and Time Functions Guide

The document outlines a series of instructions for using formulas in a spreadsheet to calculate various date-related information, including the day of the week for dates in column A and the current date and time. It also includes calculations for future and past dates, as well as a program completion timeline based on workout sessions. The document provides a structured format for organizing this data, including instructor names and workout types.

Uploaded by

jjbhzdc86n
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

1.

In clolumn B, add a formula that will display the day of the week as a
number of the date indicated in column A of the same row. (Sunday=1, Saturday=7).
2. Use a function in cell D8 to calculate the date and time right now
3. Use a function in cell D9 to calculate today's date
4. In cell F8, use a formula to to calculate the date that will be 30 days from now
5. In cell F9, use a formula to calculate what the date was 45 days before the current
6. In cell i8, Use a function and the information in cells i9:i10 to calculate when the w
Now 1/16/2026 9:50
Today 1/16/2026
Date Day of the Week Hour Instructor
4/1/2021 Thursday 10:00 AM Pamela
4/1/2021 Thursday 2:00 PM Tony
4/1/2021 Thursday 7:00 PM Angela
5/1/2021 Saturday 10:00 AM Tony
5/1/2021 Saturday 2:00 PM Pamela
5/1/2021 Saturday 7:00 PM Angela
6/1/2021 Tuesday 10:00 AM Tony
6/1/2021 Tuesday 2:00 PM Angela
6/1/2021 Tuesday 7:00 PM Pamela
7/1/2021 Thursday 10:00 AM Tony
7/1/2021 Thursday 2:00 PM Angela
7/1/2021 Thursday 7:00 PM Pamela
8/1/2021 Sunday 10:00 AM Tony
8/1/2021 Sunday 2:00 PM Angela
8/1/2021 Sunday 7:00 PM Pamela
y the day of the week as a
the same row. (Sunday=1, Saturday=7).
te and time right now
's date
date that will be 30 days from now
he date was 45 days before the current date
n in cells i9:i10 to calculate when the workout program will be completed
30 days from today 2/15/2026 Program Completed:
45 prior to today 12/2/2025 Start date
Program Days
Zumba
Aerobics
HIIT
LIFT
Zumba
Aerobics
Aerobics
HIIT
LIFT
Zumba
Aerobics
LIFT
HIIT
LIFT
HIIT
mpleted
6/24/2021
4/1/2021
60
1. In clolumn B, add a formula that will display the day of the week as a
number of the date indicated in column A of the same row. (Sunday=1, Saturday=7).
2. Use a function in cell D8 to calculate the date and time right now
3. Use a function in cell D9 to calculate today's date
4. In cell F8, use a formula to to calculate the date that will be 30 days from now
5. In cell F9, use a formula to calculate what the date was 45 days before the current
6. In cell i8, Use a function and the information in cells i9:i10 to calculate when the w
Now 1/16/2026 9:50
Today 1/16/2026
Date Day of the Week Hour Instructor
4/1/2021 Thursday 10:00 AM Pamela
4/1/2021 Thursday 2:00 PM Tony
4/1/2021 Thursday 7:00 PM Angela
5/1/2021 Saturday 10:00 AM Tony
5/1/2021 Saturday 2:00 PM Pamela
5/1/2021 Saturday 7:00 PM Angela
6/1/2021 Tuesday 10:00 AM Tony
6/1/2021 Tuesday 2:00 PM Angela
6/1/2021 Tuesday 7:00 PM Pamela
7/1/2021 Thursday 10:00 AM Tony
7/1/2021 Thursday 2:00 PM Angela
7/1/2021 Thursday 7:00 PM Pamela
8/1/2021 Sunday 10:00 AM Tony
8/1/2021 Sunday 2:00 PM Angela
8/1/2021 Sunday 7:00 PM Pamela
y the day of the week as a
the same row. (Sunday=1, Saturday=7).
te and time right now
's date
date that will be 30 days from now
he date was 45 days before the current date
n in cells i9:i10 to calculate when the workout program will be completed
30 days from today 2/15/2026 Program Completed:
45 prior to today 12/2/2025 Start date
Program Days
Zumba
Aerobics
HIIT
LIFT
Zumba
Aerobics
Aerobics
HIIT
LIFT
Zumba
Aerobics
LIFT
HIIT
LIFT
HIIT
mpleted
6/24/2021
4/1/2021
60

You might also like