I have question about time zones

[VOYAGER22]

I was wondering is eastern time zone date will change at midnight eastern time?





Thanks You

[Sam Capricci]

Not sure I understand your question, but the date changes at midnight in each time zone.

[VOYAGER22]

mostly for eastern time.

[Sam Capricci]

I'm still not clear on what your question is and if I answered it but...
as I'm writing the local (eastern time zone) is 11:45 p.m. 9/18/21 and in 15 minutes it will be midnight eastern time and at 12:00:01 it will be 9/19/21 while if you are in the central time zone it would be an hour and 15 minutes until 9/19 for you. Hope that helps.

[janmorris]

in row 2, change the formatting to:

Please Login or Register  to view this content.

include the year information in cell A2, the other cells will change correctly

delete row 3

[VOYAGER22]

I'm still not clear on what your question is ...

i need a formula or vba code when hit midnight change the date next day

[AliGW]

Did you try what was suggested in post #5?

Try responding to questions in more detail - your answers are short and bordering on the cryptic.

[VOYAGER22]

When clock say 12:00 AM. The date will change automatically to next date
for sample 9/19/21 12AM come date say 9/20/21. I want formula or vba code made to work. for eastern time


Thanks You

[Sam Capricci]

Are you talking about the NOW formula? =NOW()
every time you click in a cell then out or hit save it will put the time in that cell. Then format the cell as a date.
will that work for you?
or are you talking about embedding an actual clock in your workbook?

[VOYAGER22]

I have try formatting other day. I do not like it. I like want Ihave. on eastern time cell want change automatically

[VOYAGER22]

Are you talking about the NOW formula? =NOW()
every time you click in a cell then out or hit save it will put the time in that cell. Then format the cell as a date.
will that work for you?
or are you talking about embedding an actual clock in your workbook?

that is my next step do a embed clock. after i get this date thing working first

[JeteMc]

Looking at the file attached to post #1 I feel that you'll get what you want by putting =B2 in cell B3 and =C2 in cell C3.
When cell A2 displays 11:00 PM then cell C3 will display Wednesday, September 22, 2021 (note that the width of column C needs to be increased)
When cell A2 displays 12:00 AM then both cells A3 and C3 will display Wednesday, September 22, 2021
When cell A2 displays 2:00 AM then cells A3:C3 will display Wednesday, September 22, 2021
You may leave cells A3:C3 formatted as they are in the file attached to post #1.
Let us know if you have any questions.