Google Spreadsheet，找到前一个工作日 [英] Google Spreadsheet, finding the previous weekday

问题描述

在Google Spreadsheet中，或者在excel相同的情况下，在excel中，仅当D不是工作日本身时，才如何查找D的最后一个工作日.

In Google Spreadsheet, or excel if its the same, how do I find the last weekday of day D only if D is not a weekday itself.

IE:

If D equals weekday = do nothing (D equals D).
If D equals weekend = D equals last weekday.

我尝试过这样一个月的工作日:

i tried this to get the workday one month away:

WORKDAY(EDATE(N18, 1)+1, -1)

但是我得到了一些奇怪的结果.也许它也算是红色的日子，但我从未在任何地方指定该地区.

But I Was getting some weird results. Perhaps it counts red days as well, but I never specified the region anywhere.

再次

以上示例实际上有效，例如:

This above example actually works, eg:

=WORKDAY("2013-04-06"+1, -1)

推荐答案

=WORKDAY("2013-04-06"+1, -1)

...可以解决问题.

...does the trick.

这篇关于Google Spreadsheet，找到前一个工作日的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！