Received is a function in Google Sheets that calculates the difference between the current date and the date that a cell or range of cells is filled with. Received can be used to track when a document was last updated, or to keep a running total of how many days have passed since a particular event.
The RECEIVED function in Google Sheets returns the number of days between the date you enter and the date that the function receives as an input. The syntax is as follows:
=RECEIVED(date1, date2)
Received is a function in Google Sheets that calculates the difference between the timestamp of an incoming email and the current timestamp. This function can be used to track the age of an email, or to see when an email was received in relation to another event.
There are times when you should not use the RECEIVED function in Google Sheets. For example, if you are working with a list of data that is not in chronological order, then you should not use the RECEIVED function. The RECEIVED function will only work with data that is in chronological order.
There are many formulae that are similar to RECEIVED in Google Sheets. Some of these formulae include AVERAGE, SUM, and COUNT. These formulae can be used to calculate averages, sums, and counts of data in a range of cells. Additionally, these formulae can be used to calculate values that are based on other values in a range of cells.