由网友(情丶剩)分享简介:对于任何给定的日期,你会怎么觉得最后完成一周的周结束日期,如果你每周从周日运行至周六?解决方案 日期时间StartOfWeek = DateTime.Today.AddDays( - (INT)DateTime.Today.DayOfWeek);日期时间EndOfLastWeek = StartOfWeek.Ad...![excel中如何作到日期和星期自动,](https://p.xsw88.cn/allimgs/daicuo/20230902/193.png)
对于任何给定的日期,你会怎么觉得最后完成一周的周结束日期,如果你每周从周日运行至周六?
解决方案 日期时间StartOfWeek = DateTime.Today.AddDays( - (INT)DateTime.Today.DayOfWeek);
日期时间EndOfLastWeek = StartOfWeek.AddDays(-1);
For any given date, how would you find the week ending date of the last completed week, if your week runs from Sunday to Saturday?
解决方案![excel中如何作到日期和星期自动,](https://p.xsw88.cn/allimgs/daicuo/20230902/193.png)
DateTime StartOfWeek = DateTime.Today.AddDays(-(int)DateTime.Today.DayOfWeek);
DateTime EndOfLastWeek = StartOfWeek.AddDays(-1);
相关推荐
最新文章