the format is this 1984-03-03T00:00:00.000Z but require month, date, and year because i want to create a pivot report in google sheets for a monthly report.

can anyone help me with this?

1 Answer 1


ISO-8601 Date Format

Your values are in ISO-8601 format. The simplest way to convert them is to use the DATEVALUE function.


DATEVALUE converts a provided date string in a known format to a date value.
Syntax: DATEVALUE(date_string)

Basic Formula

# Time would be similar

You would paste the formula down the column or alternatively use the BYROW function.

BYROW Function

BYROW groups an array by rows by application of a LAMBDA function to each row.
Syntax: BYROW(array_or_range,LAMBDA)

BYROW Formula

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.