We raised a $20m Series A led by Coatue + Accel! Click here to read the announcement.

Google Sheets

The DATE function in Google Sheets returns the date corresponding to the given year, month, and day. For example, the following formula returns "August 1, 2019":

=DATE("2019", 8, 1)

The DATE function can also be used to calculate the number of days between two dates. For example, the following formula returns "42":

=DATE("2019", 7, 1) - DATE("2018", 7, 1)

date in Google Sheets is written as "="DATE(year, month, day)" where year, month, and day are the respective numbers of the year, month, and day you want the date to be.

To find the day of the week for a given date, you can use the DATE function in Google Sheets. For example, the following formula returns the day of the week for the date in A1:

=DATE(A1)

This will return a number from 1-7, where 1 is Sunday, 2 is Monday, and so on.

There are a few occasions when you might not want to use the DATE function in Google Sheets. If you are working with a table of data that is not chronological, for example, you might want to use the RAND function to generate a random number instead of the DATE function. If you are creating a formula that will calculate a future date, you can use the TODAY() function to get the current date and then add the number of days you want to the future.

There are a few similar formulae to DATE in Google Sheets. The DATEVALUE function takes a text string and converts it to a date. The DAY function takes a date and returns the day of the month. The MONTH function takes a date and returns the month of the year. The YEAR function takes a date and returns the year. The TODAY function returns the current date. The NOW function returns the current date and time. The DATE function takes two arguments, a year and a month, and returns a date. The EOMONTH function takes a date and a month and returns the last day of the month. The EDATE function takes a date and a month and returns the date of the month that is the number of months away from the date given. The AVERAGE function calculates the average of a set of numbers. The SUM function calculates the sum of a set of numbers. The MAX function calculates the maximum value in a set of numbers. The MIN function calculates the minimum value in a set of numbers.

Get started with Causal today.

Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.

Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.