How to Convert a Date to a Timestamp in Google Sheets

preview_player
Показать описание
In this video, I show how to convert a timestamp to a date in Google Sheets. A timestamp is a DateTime value that has both a date and time in it. Sometimes you may want to remove the time part of this and extract the date. This is what I show in this video.

Read through the full tutorial here:

Timestamps:
00:00 Intro
00:39 Timestamp Basics
1:42 Format Timestamp as Date
2:42 Convert Timestamp to Date with TO_DATE
4:44 Extract Date from Timestamp with SPLIT
Рекомендации по теме
Комментарии
Автор

This video has a wrong title unfortunately. I was looking how to convert a date into a timestamp

OrangStefan