ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] EXCEL ¨Ì²£«~§O§PÂ_¬O§_¥i¥Î

[µo°Ý] EXCEL ¨Ì²£«~§O§PÂ_¬O§_¥i¥Î

Dear all,

¤p§Ì¦³¤@»Ý¨D¤º®e»¡©ú¦p¤U¡G

±ø¥ó
1.²£«~Äæ¦ì¡Ac6¡Bc66¤J®w¦~¤ë¦b1¦~¤º(±q¤µ¤Ñ©¹¦^±À365¤Ñ)ºâ¬O¥i¥Î¡C
2.²£«~Äæ¦ì¡A°£¤Fc6¡Bc66¥~ªº²£«~«h¬°2¦~(±q¤µ¤Ñ©¹¦^±À730¤Ñ)¤º¡C
3.¦bÄæ¦ìd¡A·QÅã¥Ü§PÂ_¬O§_¥i¥H¨Ï¥Î
4.­YÄæ¦ìc¤º¬OªÅ¥Õªº¡AÄæ¦ìd´N¤£Åã¥Ü
5.­YÄæ¦ìa¤º¬OªÅ¥Õªº¡AÄæ¦ìd´N¤£Åã¥Ü

¦A³Â·Ð¦U¦ì¥ý¶i¸Ñ´b¡C  

·P®¦¡I

§PÂ_¦¡.rar (8.79 KB)

§PÂ_¦¡.jpg
2020-3-25 19:36
Just do it.

=IF(COUNTA(A2:C2)<3,"",IF(TODAY()-DATE(A2+1911,B2+1,0)>2^AND(C2<>{"C6","C66"})*365,"¤£",)&"¥i¥Î")

TOP

¦^´_ 2# ­ã´£³¡ªL

Dear ­ã´£³¡ªL,

«D±`·PÁ±zªºÀ°¦£Åo¡I ^_^
Just do it.

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD