StaceyVECL
New Member
- Joined
- Apr 13, 2022
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
Hi, I need to convert EST to GMT time including day and date.
For example
Column A and column C are manual inputs
I have formulas in B and D that are working.
However, I would like column E to show that it would be the following day in GMT as it's past midnight. Can this be done?
Thank you in advance.
For example
| A | B | C | D | E |
| Date | Day EST | EST | GMT | Day GMT |
| 01/11/2023 | Wednesday | 21:00 | 01:00 | I would like this to show it would be Thursday. |
Column A and column C are manual inputs
I have formulas in B and D that are working.
However, I would like column E to show that it would be the following day in GMT as it's past midnight. Can this be done?
Thank you in advance.
