Excel WEEKDAY関数で曜日に

Standard
=IF( ISERROR(WEEKDAY("20" & LEFT(TRIM($G$8),2)&"/"& $B$1& "/" &A12)),"",WEEKDAY("20" & LEFT(TRIM($G$8),2)&"/"& $B$1 & "/" &A12))

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.