My worksheet contains a formula to change the date in A2 to
Text in B2 indicating the day of the week. I need a formula in C2 that
would take the date in cell A2 and take into consideration the time in
cell D2. My company's day starts at 06:00 and runs until 06:00 the
next day. I want C2 to show the next day after midnight.

Example: B2 would show Tues for the date 5/31/2005, but after midnight
(in D2), I want C2 to show Wed.


+-------------------------------------------------------------------+
|Filename: DayNumber formula.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=3446 |
+-------------------------------------------------------------------+

--
dcoates
------------------------------------------------------------------------
dcoates's Profile: http://www.excelforum.com/member.php...fo&userid=2320
View this thread: http://www.excelforum.com/showthread...hreadid=375616