- ©«¤l
- 1
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1
- ÂI¦W
- 0
- §@·~¨t²Î
- win 10
- ³nÅ骩¥»
- 2013
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2015-11-24
- ³Ì«áµn¿ý
- 2015-11-24
|
¦^´_ 1# jessicawu
¥i¥H®M¥Î¨ì©Ò¦³ªºEXCELª©¥»¶Ü?
=IF(DATEDIF(F2,TODAY()-(H2-G2),"y")<10,LOOKUP(DATEDIF(F2,TODAY()-(H2-G2),"y"),$Q$1:$Q$4,$R$1:$R$4),MIN(30,DATEDIF(F2,TODAY()-(H2-G2),"y")-9+14))
¥t¥~¥i¥H½Ð±Ð¤j¤j³o¼Ë¼gþ¸Ì¦³¿ù¤F?? |
|