I'm looking for a formula to extract the date to Column G (number). The date/time is in Column D in the format "m/d/yyyy h:mm" (Ex: 9/1/2012 12:01:21 AM).
The date will start at 6:00:00am and end at 5:59:59am the next day.
For example, 9/3/2012 12:01:21 AM or 9/3/2012 5:59:21 AM should return date 2.
Thank you.
The date will start at 6:00:00am and end at 5:59:59am the next day.
For example, 9/3/2012 12:01:21 AM or 9/3/2012 5:59:21 AM should return date 2.
Thank you.