Thread
:
Tricky IF/Then Date based formula needed
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Tricky IF/Then Date based formula needed
First, Look at the AND function. Then,the OR function and then the IF
function. Put together in that order.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Titanium" wrote in message
...
Column A has the date and time displayed: Thu, 06/14/07, 11:15
Column B needs to calculate: "If (A=Mon to Fri from 7:00 to 20:00, Sat
from
7:00 to 15:00, Sun from 7:00 to 16:00 Then Display in Column B "On Time")
If False then Display in Column B "Closure Time")
I don't even know where to start with this one. Any assistance would
certainly be appreciated. Thanks in advance for your help.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett