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

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.

I have never used "sql" before ??

Hi,

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

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"

Try this formula in cell D2:

=--LEFT(B2:B4, 10)

or this formula:

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

Format cells as date.

Hope this helps.