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

[µo°Ý] ¤U­Ó¤ë·sÀÉ

¦^´_ 20# PJChen
Sheets("1").Range("A2")ªº¤é´Á(2020/4/1),§ì¤ë©³¤é
Lastday = DateSerial(Year(BK.Sheets("1").Range("A2")), Month(BK.Sheets("1").Range("A2")), 0) '¤ë©³¤é
³o¼ËLastday¬O2020/3/31
mDay = Day(Lastday)¬O31
§ï¦¨Lastday = DateSerial(Year(BK.Sheets("1").Range("A2")), Month(BK.Sheets("1").Range("A2")) +1, 0) '¤ë©³¤é
Lastday¬O2020/4/30
mDay = Day(Lastday)¬O30

TOP

¦^´_ 21# jcchiang

¦nªº,´ú¸Õ¦¨¥\¤F
·PÁÂ

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD