IF statement adding a day to a date from 12:00am - Help!

[MurraySMTH]

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.

 

[Joe4]

You are welcome.
Glad we were able to help.