=IF(A3="","",DATEDIF(TEXT((LEN(A3)=15)*19&MID(A3,7,6+(LEN(A3)=18)*2),"#-00-00"),TODAY(),"y"))这个公式中如何实现到系统日期的上个月月底的年龄

=IF(A3="","",DATEDIF(TEXT((LEN(A3)=15)*19&MID(A3,7,6+(LEN(A3)=18)*2),"#-00-00"),TODAY(),"y"))
这个公式中如何实现到系统日期的上个月月底的年龄

=IF(A3="","",DATEDIF(TEXT((LEN(A3)=15)*19&MID(A3,7,6+(LEN(A3)=18)*2),"#-00-00"),TODAY()-DAY(TODAY()),"y"))
TODAY()换为TODAY()-DAY(TODAY())
也就是今天减去今天的号数,等于上月最后一天.