首日,数组公式 =TEXT(A1-MATCH(1,WEEKDAY(A1-(ROW(1:7)-1),1),)+1,"yyyy-mm-dd") 据首日求末日 =TEXT(B1+6,"yyyy-mm-dd") 直求 =TEXT(A1+MATCH(7,WEEKDAY(A1+(ROW(1:7)-1),1),)-1,"yyyy-mm-dd") |
| 百度统计|小黑屋|菜鸟站长联盟
( 陇ICP备15000550号-2 )|
GMT+8, 2021-1-19 19:12 , Processed in 0.071765 second(s), 19 queries .
技术支持:李海 Tel/WeChat:18298346873
© 2013-2021 www.nbabbc.com