If function

[Maci3j]

Dear Readers,

How can I create a valid IF function for the fallowing hypothesis:

IF shutdowndate < startdate =OK
IF shutdowndate < startdate = Not OK

The day and month column can NOT be merged because the month-column will be needed for the filter-function.
Thanks in advance for your help

	Shutdown		Start		Status
	day	month	day	month
	10	april	12	may

<TBODY>
</TBODY>

 

[FormR]

Maybe like this:

Excel Workbook
	A	B	C	D	E
1	Shutdown		Start		Status
2	day	month	day	month
3	10	april	12	may	OK
Sheet1

 

[Maci3j]

Thank you very much FormR. You helped me a lot !!!