How do I change this to "text" or another formula in order to change data from this format to "day"

Try this formula in cell D2:

=--LEFT(B2:B4, 10)

or this formula:

=--REGEXEXTRACT(B2:B4, "^.{10}")

Format cells as date.

Hope this helps.

This code in Power Query works as well

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"StartInterval", type datetimezone}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each DateTimeZone.RemoveZone([StartInterval]), type date)
in
    #"Added Custom"

Hi,

Select the range of cells and press Ctrl+H. In the Find What box, type T* (T and star). Click on Replace All.

I have never used "sql" before ??

Hi Anonymous

Thank you for contacting Q&A Forum.

The timestamp you provided:2025-08-01T00:00:00.000-04:00 is in ISO 8601 format, which is a standardized way to represent date and time including timezone offset.

To convert it into a readable format, you can use the following formula

=DATEVALUE(MID(b2,1,10))+TIMEVALUE(MID(b2,12,8))

or

=TEXT(DATEVALUE(MID(c2,1,10)), "dddd")

Hope this can help you out!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.