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

[µo°Ý] ¤é´ÁDATE¹Bºâ¿ù»~

=IF(MONTH(DATE($D$1+1911,$F$1,COLUMN(A1)))<>$F$1,"",DATE($D$1+1911,$F$1,COLUMN(A1)))

¥Á°ê¦~¶·¥[1911
¥k©Ô¥²¶·¨Ï¥Î COLUMN()

TOP

¢Ó¢²¡G
=IFERROR(--($D$1+1911&-$F$1&-COLUMN(A1)),"")¡@¡@¥k©Ô

¢Ó¢³¡G
=RIGHT(TEXT($D$1+1911&-$F$1&-COLUMN(A1),"aaa;;;"))¡@¡@¥k©Ô

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD