MurraySMTH
Board Regular
- Joined
- Jun 30, 2020
- Messages
- 81
- Office Version
- 2016
- Platform
- Windows
Hello,
I am trying to solve a simple IF statement by adding one day to a date from a cell containing time.
=IF(L3>Time(12,00,0)Datevalue(J3+1))
So if L3 is higher that 12:00am add one day to the date in J3
If this is not the case, no change to date.
Thank you for any effort provided! Love this forum.
I am trying to solve a simple IF statement by adding one day to a date from a cell containing time.
=IF(L3>Time(12,00,0)Datevalue(J3+1))
So if L3 is higher that 12:00am add one day to the date in J3
If this is not the case, no change to date.
Thank you for any effort provided! Love this forum.