rizwanulhasan
New Member
- Joined
- Jan 1, 2022
- Messages
- 16
- Office Version
- 2021
- Platform
- Windows
Hi,
In the attached image below, i want exact 1 day to be added to the date in cell C2 i.e. 24 hrs excluding the holidays mentioned in Sheet 1.
However, the time i receive in the cell D2 is always 12:00 AM whereas I want it to be 6:00 PM. i.e. date should change but the time remains as in the cell C2.
Can some one please guide with the correct formula.
Thanks in advance.
In the attached image below, i want exact 1 day to be added to the date in cell C2 i.e. 24 hrs excluding the holidays mentioned in Sheet 1.
However, the time i receive in the cell D2 is always 12:00 AM whereas I want it to be 6:00 PM. i.e. date should change but the time remains as in the cell C2.
Can some one please guide with the correct formula.
Thanks in advance.