如何计算SharePoint下个月的第一个星期五? [英] How do I calculate the first friday of next month in SharePoint?

问题描述

我被要求从< g class ="gr_ gr_63 gr-alert gr_gramm gr_inline_cards gr_run_anim仅语法-ins replaceWithoutSep"中更改通知. data-gr-id ＝"63". id ＝"63"＞第一/g.一个月中的第一个星期五至的第一个星期五 每月.我尝试对公式进行一些更改，但未成功.我在这里看到了下个月第一个星期一的公式，看起来很简单，但是我不确定如何将其修改为第一个星期五.

Romeo< g class ="gr_ gr_271 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id ="271" id ="271"> Dunca//g 在第一个星期一使用此公式:

( )；  )+  ( (  Data1  ( ( )+  ( (  Data1  ( ( )+  ( (  Data1  ( ( )+  ( (  Data1  ( ( )+  ( (  Data1  ( ( )+  ( (  Data1  ( (  Data1  解决方案

http://romeodonca.com/calculated-column-get-第一个月下一个星期一/

就像帖子中所说的那样，尽管公式很长，但您需要更改的只是红色数字，以满足您的要求.

现在公式为星期一，我们需要将其更改为星期五，因此我们将前1设置为5，然后将下4、3、2、1等设置为

 = IF(WEEKDAY(DATE(YEAR(Data1)，MONTH(Data1)+1,1))= 5
，DATE(YEAR(Data1)，MONTH(Data1)+ 1、1 + 1)，
IF(WEEKDAY(DATE(YEAR(Data1)，MONTH(Data1)+1,1))= 4
，DATE(YEAR(Data1)，MONTH(Data1)+ 1、1 + 2)，
IF(WEEKDAY(DATE(YEAR(Data1)，MONTH(Data1)+1,1))= 3
，DATE(YEAR(Data1)，MONTH(Data1)+ 1、1 + 3)，
IF(WEEKDAY(DATE(YEAR(Data1)，MONTH(Data1)+1,1))= 2
，DATE(YEAR(Data1)，MONTH(Data1)+ 1、1 + 4)，
IF(WEEKDAY(DATE(YEAR(Data1)，MONTH(Data1)+1,1))= 1
，DATE(YEAR(Data1)，MONTH(Data1)+ 1、1 + 5)，
IF(WEEKDAY(DATE(YEAR(Data1)，MONTH(Data1)+1,1))= 7
，DATE(YEAR(Data1)，MONTH(Data1)+ 1,1 + 6)，DATE(YEAR(Data1)，MONTH(Data1)+1,1)))))))))))))))))))

I was asked to change a notification from <g class="gr_ gr_63 gr-alert gr_gramm gr_inline_cards gr_run_anim Grammar only-ins replaceWithoutSep" data-gr-id="63" id="63">first</g> day of the month to first Friday of each month. I tried a few alterations to my formula but was not successful. I saw here a formula for first Monday of the next month and seems simple enough, but I am not sure how to modify it to First Friday. 

Romeo <g class="gr_ gr_271 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="271" id="271">Dunca</g> uses this formula for first Monday: 

IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=1;DATE(YEAR(Data1);MONTH(Data1)+1;1+1);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=7;DATE(YEAR(Data1);MONTH(Data1)+1;1+2);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=6;DATE(YEAR(Data1);MONTH(Data1)+1;1+3);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=5;DATE(YEAR(Data1);MONTH(Data1)+1;1+4);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=4;DATE(YEAR(Data1);MONTH(Data1)+1;1+5);IF(WEEKDAY(DATE(YEAR(Data1);MONTH(Data1)+1;1))=3;DATE(YEAR(Data1);MONTH(Data1)+1;1+6);DATE(YEAR(Data1);MONTH(Data1)+1;1)))))))

 How do I modify it to first Friday?

解决方案

http://romeodonca.com/calculated-column-get-first-monday-on-the-next-month/

like the post says, all you need to change is the red number to meet your requirement, though the formula is really long.

Now the formula is Monday, we need to change it to Friday, so we set first 1 to 5, and next 4, 3, 2, 1, etc.

=IF(WEEKDAY(DATE(YEAR(Data1),MONTH(Data1)+1,1))=5
,DATE(YEAR(Data1),MONTH(Data1)+1,1+1),
IF(WEEKDAY(DATE(YEAR(Data1),MONTH(Data1)+1,1))=4
,DATE(YEAR(Data1),MONTH(Data1)+1,1+2),
IF(WEEKDAY(DATE(YEAR(Data1),MONTH(Data1)+1,1))=3
,DATE(YEAR(Data1),MONTH(Data1)+1,1+3),
IF(WEEKDAY(DATE(YEAR(Data1),MONTH(Data1)+1,1))=2
,DATE(YEAR(Data1),MONTH(Data1)+1,1+4),
IF(WEEKDAY(DATE(YEAR(Data1),MONTH(Data1)+1,1))=1
,DATE(YEAR(Data1),MONTH(Data1)+1,1+5),
IF(WEEKDAY(DATE(YEAR(Data1),MONTH(Data1)+1,1))=7
,DATE(YEAR(Data1),MONTH(Data1)+1,1+6),DATE(YEAR(Data1),MONTH(Data1)+1,1)))))))

这篇关于如何计算SharePoint下个月的第一个星期五?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！