如果只返回这个加分减分的值得话,下面函数可以,这里自动把时间提取出来(很长很带劲),无需关注字符串格式,只需要保证日期格式在字符串中是XXX年XXX月XX日即可:
=IF(TEXT(F7,"yyyy/mm/dd")<TEXT(RIGHT(LEFT(C6,FIND("日",C6,1) ),LEN(LEFT(C6,FIND("日",C6,1) )) - FIND("年",LEFT(C6,FIND("日",C6,1) ),1) +5),"yyyy/mm/dd"),5,IF(AND(TEXT(F7,"yyyy/mm/dd")>=TEXT(RIGHT(LEFT(C7,FIND("日",C7,1) ),LEN((LEFT(C7,FIND("日",C7,1) ))) -FIND("年",(LEFT(C7,FIND("日",C7,1) )),1) +5),"yyyy/mm/dd"),TEXT(F7,"yyyy/mm/dd")<=TEXT(RIGHT(LEFT(C7,FIND("日",C7,FIND("日",C7,1) + 1) ),LEN((LEFT(C7,FIND("日",C7,FIND("日",C7,1) + 1) ))) -FIND("年",(LEFT(C7,FIND("日",C7,FIND("日",C7,1) + 1) )),FIND("日",C7,1) + 1) + 5),"yyyy/mm/dd")),-5,IF(AND(TEXT(F7,"yyyy/mm/dd")>=TEXT(RIGHT(LEFT(C8,FIND("日",C8,1) ),LEN((LEFT(C8,FIND("日",C8,1) ))) -FIND("年",(LEFT(C8,FIND("日",C8,1) )),1) +5),"yyyy/mm/dd"),TEXT(F7,"yyyy/mm/dd")<=TEXT(RIGHT(LEFT(C8,FIND("日",C8,FIND("日",C8,1) + 1) ),LEN((LEFT(C8,FIND("日",C8,FIND("日",C8,1) + 1) ))) -FIND("年",(LEFT(C8,FIND("日",C8,FIND("日",C8,1) + 1) )),FIND("日",C8,1) + 1) + 5),"yyyy/mm/dd")),-10,-100)))
附图如下: