Hang tight while we fetch the video data and transcripts. This only takes a moment.
Connecting to YouTube player…
Fetching transcript data…
We’ll display the transcript, summary, and all view options as soon as everything loads.
Next steps
Loading transcript tools…
Google Sheet Date Functions | DigiSkills | YouTubeToText
YouTube Transcript: Google Sheet Date Functions
Skip watching entire videos - get the full transcript, search for keywords, and copy with one click.
Share:
Video Transcript
Video Summary
Summary
Core Theme
This video tutorial demonstrates various essential date and time functions in Google Sheets, covering formatting, extraction, calculation, and manipulation of dates for practical applications like project management and financial planning.
Mind Map
Click to expand
Click to explore the full interactive mind map • Zoom, pan, and navigate
in this video we will learn how to work
with date functions in Google Sheets
let's start from task number one where
we may see just the numbers on ABC
columns and our task is to convert them
in the format of date and time first
let's highlight the given numbers on a
column and in order to convert the given
numbers on date format let's go to
format choose H
date and in order to convert the given
numbers in Long date format the same
steps however we will choose here custom
dat and time and from the given list you
may choose here long date format
apply okay and last one to convert the
given numbers in the format of time
again numbers select from the given list
time in this example let's learn how to
find today's date by just applying the function
function
today after that let's learn how to get
today's time as well let's apply the
function now enter button that's the
time and now let's learn how to extract
from given date a day month and year
equal sign as a name says we will apply
H day function okay and as an argument
give the following first day press the
enter okay then I will just copy down my
formula the same step with the mons
equal to the function name
months press the enter okay so in the
following date examples the first comes
month and then comes date and then comes
year so here you can see 11 it is
November the same with the year equal sign
here okay here we are next step how to
extract day and month names equal sign
we have to apply here the function text
argument it's our date and I would like
to return day name in the format of DDD
and this four means you'll get the day
name in full format in case if I will
apply just three days and then I will
get the shorten version of day
names the same with the mons equal sign
text argument and then in the full
format of
months okay the last two columns we have
to first identify here weekday and then
uh identify is this day weekend or
weekday so equals find we have a
function named
weekday with the address of date press
the enter the output is basically for
international format where weekday
starts from Sunday uh in my case it has
to start from Monday next to your first
argument if you'll indicate number two
which means your week starts from Monday
not from Sunday and then I will copy
down my
formula okay is this day is weekend or
not we will just use IF function if my
Wick day is bigger than number
five then it is
weekend otherwis this is no so number
six it means Saturday weekend Saturday
again and Sunday weekend the rest of
them they
weekday okay the reverse steps we have a
year month and day in order to get a
date again we will use the function date
year comma months comma and date the
same with a Time
Time
Time hour minute and
second okay in the third example let's
learn how to calculate finish date for
specific task where we have start date
and work days in order to calculate
finish date we have to consider holidays
in our country we have like basic New
Year Holidays international women's day
n holiday and so on in order to get my
finished date let's apply function
workday where this function will
consider three arguments which are start
day number of days and hold days first
start day comma work days comma and then
I have to highlight the range of all my
holidays okay if I will start this task
on this date and if it gives me 14 days
to complete my finish date will be 22nd
of January okay if you will add for the
first day of January last 14 days it
might be 15 days uh however we got
number 22 which means the function uh
removed all Saturdays and Sundays plus
if in this period of time we have a
holidays as we have mentioned here it
will be again extract uh before to copy
down you have to make sure the range
where we have applied uh as our holidays
has to be an absolute reference now Vice
Versa steps again we have list of tasks
to complete we have start date end date
and then my task is to Define how many
days I have to complete the given task
okay to get the reverse tab I will apply
the function Network days where the
function take start date and date and
holidays as well start date comma and
date if you will give only two arguments
you will get also the network days but
it is not considering your holidays so
let's go back and add the third argument
which is our holidays
range so as you can see number six
turned out like number four uh which
means between these two days we have a
formula okay in the first task let's
learn how to calculate the age so let me
see here the student's name a birth date
and today's date using the function date
if let's calculate age date if will take
three arguments again start date end
date in unit start date is going to be
our birth date comma end date is today's
date unit it's in the format of for
example if you'll indicate the why it
means ear so the students age is
23 uh if I will indicate the D it means
dates let's copy down the
formula so we get some value mistake
which means we have
to uh make a constant the given range of
B3 which is our today's date this one
let's return B three in absolute
format okay the fourth example is about
low netization schedule we may see here
payment number payment day column is the
empty which we're going to fill out now
so we may see our monthly payment
45,000 interest paid principal
production and so on so the loan period
is for four years start date it's the 30
1st of January and
2023 uh and total number of period is 48
months so my task is to now fill out the
b column where we will indicate payment
dates which is last states of every
month okay the problem has to be solved
with EO month function first of all our
first payment dat it is already given
for us I will just give the address
second pay payment will be the last day
of next month since it's the January
next month has to be February so uh the
E month takes two arguments first is a
start date which is our January comma
and then it says months as a month if
you will indicate number one so you're
going to get February if you will
indicate number two what comes the as
the payment date will be March which is
incorrect so that's why every time our
month has to be increased by number one
and then I will just copy down so you
can see here is the last day of March
April May June July and so on so let's
copy down the formula till the end of
our loan
period so you may see here our payment
started on
2023 and the last payment will be on
2026 and last example is to learn how to
apply e dat function which allows us to
calculate future or past dates equal
sign e date so it takes two arguments
again start date and month so this is
month okay the same with the second one e
e
date again start date and now we're
going to add three
months okay so look at the example it
was January February and then plus three
it will be April plus 10 will be
November let's do the P dates Ed E
dat start date minus
okay in the short video we've learned
how to apply basic simple date functions
Click on any text or timestamp to jump to that moment in the video
Share:
Most transcripts ready in under 5 seconds
One-Click Copy125+ LanguagesSearch ContentJump to Timestamps
Paste YouTube URL
Enter any YouTube video link to get the full transcript
Transcript Extraction Form
Most transcripts ready in under 5 seconds
Get Our Chrome Extension
Get transcripts instantly without leaving YouTube. Install our Chrome extension for one-click access to any video's transcript directly on the watch page.
