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

[µo°Ý] ¦p¦ó­pºâ·í¤ë¨ì«ü©w¬Y¤ë¥÷ªº´Á¼Æ­È

[µo°Ý] ¦p¦ó­pºâ·í¤ë¨ì«ü©w¬Y¤ë¥÷ªº´Á¼Æ­È

¥»©«³Ì«á¥Ñ jackson7015 ©ó 2013-12-16 16:51 ½s¿è

1.°²³]§Ú­n­pºâ¤µ¤é¨ì104/11/25ªº´Á¼Æ(¨C­Ó¤ëºâ1´Á)
¨º¥H¤Uªº¤½¦¡­n¦p¦óºë²¡A©Î§ó¦³®Ä²v?
A1¡G104/11/25
B1=((12-MONTH(TODAY()))+1)+(12*(LEFT(A1,3)-(LEFT(TODAY(),3)-314)-1))+MID(A1,5,2)
ps.·í¤ë¥÷¤]»Ýºâ¶i¥h

2.©Ó¤W¡A°²³]¤À¦¨¥u­pºâ³æ¤ë¥÷©ÎªÌÂù¤ë¥÷ªº³¡¤À
­YC1Åã¥Ü³æ¤ë©ÎÂù¤ë¡A«h­pºâ¸Ó³æÂù¤ë´Á¼Æ
¸Ó¦p¦ó½s¼g ?
ps.·í¤ë¥÷¤]¶·¨Ö¤J³æÂù¤ë­pºâ

ÁÂÁÂ~:)

¥»©«³Ì«á¥Ñ p212 ©ó 2013-12-16 17:29 ½s¿è

¦^´_ 1# jackson7015
°Ñ»P°Q½×¡u­pºâ¤µ¤é¨ì104/11/25ªº´Á¼Æ(¨C­Ó¤ëºâ1´Á)¡v¤§¥t¤@ºØºâªk¡G
B1=ROUNDUP(YEARFRAC(TODAY(),DATE(LEFT(A1,3)+1911,MID(A1,5,2),RIGHT(A1,2)),0)*12,0)
¨Ï¥ÎYEARFRAC¨ç¼Æ¥iºë·Ç¦a­pºâ¨â­Ó¤é´Á¬Û®t¦h¤Ö¦~(­pºâ¦Ü¤p¼Æ¦ì)
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212

·PÁÂP¤jªº¨ó§U
ªº½T¥i¥H¨Ï¥ÎYEARFRAC¨Óºë²Ó­pºâ

¥Ø«e­pºâ©_¼Æ©Î°¸¼Æ¤ë¥÷ªº®É­Ô¡A¦³¨Ç°ÝÃD
¥H¤U¬O§ï¥¿«áªº­pºâ¦C

B1=IF(OR(AND(LEFT(C1)="Âù",ISODD(MONTH(TODAY()))),AND(LEFT(C1)="³æ",ISEVEN(MONTH(TODAY())))),IF(LEN(A1)>0,ROUNDUP(YEARFRAC(TODAY(),DATE(LEFT(A1,3)+1911,MID(A1,5,2),RIGHT(A1,2)),0)*12,0),"")-1,IF(LEN(A1)>0,ROUNDUP(YEARFRAC(TODAY(),DATE(LEFT(A1,3)+1911,MID(A1,5,2),RIGHT(A1,2)),0)*12,0),""))

¦ý¬O·|¦³¿ù»~¡A¦]¬°­Y¬O­pºâ«á´Á¤ë¥÷¼Æ¡AµLªk¥u­pºâ©_¼Æ©Î°¸¼Æ¤ë¥÷ªº¥[Á`
¤£¾å±o¬O§_¤]¬O§Q¥ÎISODD©MISEVEN¨Ó°µ­pºâ ?

TOP

·s¼W½d¨ÒÀÉ®×
¬¡­¶Ã¯1.rar (12.52 KB)

TOP

·Q¤F2.3¤Ñ¡A¤]·j´M¹L¯¸¤W¤@¯ë°Ïªº¬ÛÃö¼gªk
ÁÙ¬O·Q¤£¥X¸Ó«ç»ò½s¼g

¤£¾å±o¬O§_¦³¤j¤j¯àÀ°¦£ ?
ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ softsadwind ©ó 2013-12-27 11:43 ½s¿è

¦^´_ 5# jackson7015

       ¬¡­¶Ã¯1.zip (11.69 KB)
    §Ú§â§Aªº¤é´Á®æ¦¡­«·s¿é¤J¤@¦¸¡A§ïÅܮ榡¦¨¬°¤é´Á¡A¥Î¤¤µØ¥Á°ê¾äÅã¥Ü¥X¨Ó
   

     °Ñ¦Ò¬Ý¬Ý.....

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 6# softsadwind

   
    E3 = DATE(YEAR(D3),MONTH(D3)+(F3-1),25)

   E3§ï³o¼Ë¤l¤ñ¸û²³æ@@ ¥L¦Û°Ê·|§â¶W¹L12­Ó¤ë´«¦¨¦~¥÷...

   ¨â­Ó¤ë¤@´Áªº¤½¥q¤S¤£¤@¼Ë
   E13 =DATE(YEAR(D13),MONTH(D13)+2*F13-2,25)
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 6# softsadwind
¦^´_ 7# softsadwind

«D±`·PÁÂsoftsadwind¤j¤jªºÀ°¦£¸Ñ´b
­ì¨Ó¥i¥Hª½±µ¨Ï¥ÎDATEDIFª½±µ¨Ó°µ¤ë¥÷ªº¥[´î§PÂ_

¦Ó¥BÁÙ¶¡±µ¦aÀ°¦£°µ¤F´Á¼Æ­Ë±ÀªººI¤î¤é³¡¤À(­ì¥»¤wKEYIN)
²{¦b¤Ï¦ÓÁÙ¥i¥H°µÀ˺â

¦Û¤v¤]§Q¥Î¯S®í³æÂù¤ë­pºâ³¡¤Àªº¦a¤è°µ¤FLENªº§PÂ_
­ì¥»­n¥HLEFT°µ³æ/Âù§PÂ_¡A¤£¹L¥ÎLEN¤ñ¸û§Ö±¶ÂI
·PÁ¤j¤jªº¨ó§U~:loveliness:

TOP

¥Î¬O¤£¬O¤å¦r®æ¦¡ ¨Ó§PÂ_¥Î¨º¤@­Ó¤½¦¡
G3=IF(ISTEXT(B3),IF(A$2<E3,IF(A$2<D3,F3,IF(DAY(A$2)=DAY(D3),INT((DATEDIF(A$2+1,E3,"M")+2)/2),INT((DATEDIF(A$2,E3,"M")+2)/2))),"0"),IF(A$2<E3,IF(A$2<D3,F3,IF(DAY(A$2)=DAY(D3),DATEDIF(A$2,E3,"M"),DATEDIF(A$2,E3,"M")+1)),"0"))

°Ñ¦Ò¬Ý¬Ý
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD