Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If certain date is past certain date.
Hi everyone.
I have the following problem if you guys could please help me Two colums , as below A B C 1 Due Sent 2: 3: 15 Jan 07 16 Jan 07 4: 10 Dec 06 5: 11 Dec 06 6: 12 Dec 06 13 Dec 06 7: 24 Nov 06 I need a formula to advise SLA missed or SLA met. If Sent date is after due date then - SLA Missed If Sent date is before due date or on due date - SLA Met I have tried the following =IF(B1=A1,"SLA Missed",IF(B1<=A1,"SLA Met",IF(A1="","",(IFB2="","")) This shows a mixture of SLA Missed and SLA Met for cell containing one or both dates. Thanks all |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If certain date is past certain date.
Try:
=IF(AND(B1=A1,B1<""),"SLA Missed",IF(AND(B1<=A1,B1<""),"SLA Met","")) HTH "Angela1979" wrote: Hi everyone. I have the following problem if you guys could please help me Two colums , as below A B C 1 Due Sent 2: 3: 15 Jan 07 16 Jan 07 4: 10 Dec 06 5: 11 Dec 06 6: 12 Dec 06 13 Dec 06 7: 24 Nov 06 I need a formula to advise SLA missed or SLA met. If Sent date is after due date then - SLA Missed If Sent date is before due date or on due date - SLA Met I have tried the following =IF(B1=A1,"SLA Missed",IF(B1<=A1,"SLA Met",IF(A1="","",(IFB2="","")) This shows a mixture of SLA Missed and SLA Met for cell containing one or both dates. Thanks all |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If certain date is past certain date.
=IF(OR(A1="",B2=""),"",IF(B1=A1,"SLA Missed","SLA Met"))
"Angela1979" wrote: Hi everyone. I have the following problem if you guys could please help me Two colums , as below A B C 1 Due Sent 2: 3: 15 Jan 07 16 Jan 07 4: 10 Dec 06 5: 11 Dec 06 6: 12 Dec 06 13 Dec 06 7: 24 Nov 06 I need a formula to advise SLA missed or SLA met. If Sent date is after due date then - SLA Missed If Sent date is before due date or on due date - SLA Met I have tried the following =IF(B1=A1,"SLA Missed",IF(B1<=A1,"SLA Met",IF(A1="","",(IFB2="","")) This shows a mixture of SLA Missed and SLA Met for cell containing one or both dates. Thanks all |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If certain date is past certain date.
Excellent thanks very much everyone
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Using date and time of past crimes to project the next occurance | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
need to show when date is past due | Excel Worksheet Functions | |||
Past date in column to change color | Excel Worksheet Functions |