EXCEL 中时间转换 date-week,week-month

来源：学生作业帮编辑：拍题作业网作业帮分类：综合作业时间：2024/06/16 09:51:42

如图所示

B2的公式应该是
=WEEKNUM(A1,21)
G2的公式要麻烦一些
=IF(RIGHT(D1,2)*1>52,12,MODE(MONTH(DATE(LEFT(D1,4),1,1)+(RIGHT(D1,2)*1-1)*7+{0,1,2,3,4,5,6})))
再问：这肯定不对的。。。
再答： B2 =WEEKNUM(A2,21) G2 =IF(RIGHT(F2,2)*1>52,12,MODE(MONTH(DATE(LEFT(F2,4),1,1)+(RIGHT(F2,2)*1-1)*7+{0,1,2,3,4,5,6}))) 我在自己机子上试过可以的，刚才给你的公式把单元格写错了，我按我自己机子上的单元格写的，忘了改了。
再问： 1月的28到31号也就是第五周应该是1月份，但这个答案是2月份。。。求指导。。。
再答：改了一下G2的公式，你再看看呢。 =IF(RIGHT(F2,2)*1>52,12,MODE(MONTH(IF(WEEKDAY(DATE(LEFT(F2,4),1,1),2)>4,DATE(LEFT(F2,4),1,1)+8-WEEKDAY(DATE(LEFT(F2,4),1,1),2),DATE(LEFT(F2,4),1,1)+1-WEEKDAY(DATE(LEFT(F2,4),1,1),2))+(RIGHT(F2,2)*1-1)*7+{0,1,2,3,4,5,6})))

PHP：$week = date('w',strtotime($year.'-'.$month.'-'.$day)); this month(week)是什么时态 week 英语翻译Expected Delivery Date-year 2007 week 51(是指发出时间还是指到达时间）I 分别用year,week,month造句. I will have a week off next month.中off的语法英语翻译The captain stayed week after week,month after month.His 由于我刚学asp.week=weekday(date())-1 和 week=weekday(date()) 运行结果都 take a trip next week句型转换 Next month we'll have two holiday.A.week B.weeks' C.week's D make my day,week,month,and year这种表达是什么意思? once a week=_____ _____ a month