计算列-长度有限制吗? [英] Calculated Column - is there a limit on length?
问题描述
我的前任创建了一个名为"Calc_TaskNextStartDate"的计算列.这样可以计算出每日"，每周"，每月"和年度"任务的下一个日期.
My predecessor created a calculated column called "Calc_TaskNextStartDate". This worked out the next date for Daily, Weekly, Monthly and Annual tasks.
已要求我为每季度和每两年一次的任务添加选项.当我添加这些添加项时，会出现语法错误.但是，如果我只删除一次添加项，它就可以正常工作(不管是哪一个，所以我都不知道它的代码).我是 猜猜这是一个长度问题吗?有人可以确认吗?下面是带有附加代码的代码
I've been asked to add options for Quarterly and Bi-annual tasks. When I add these additions in, I get a syntax error. But, if I remove just once of the additions, it works fine (doesn't matter which one so I know its not the code). I'm guessing its a length issue? Can anybody confirm? The code is below with the additions
=IF([Task Recurrance]="Daily",IF(WEEKDAY([Start Date],2)=1,[Start Date]+1,IF(WEEKDAY([Start Date],2)=2,[Start Date]+1,IF(WEEKDAY([Start Date],2)=3,[Start Date]+1,IF(WEEKDAY([Start Date],2)=4,[Start Date]+1,IF(WEEKDAY([Start Date],2)=5,[Start Date]+3,IF(WEEKDAY([Start Date],2)=6,[Start Date]+2,IF(WEEKDAY([Start Date],2)=7,[Start Date]+1,0))))))),IF([Task Recurrance]="Weekly",IF(WEEKDAY([Start Date],2)=1,[Start Date]+7,IF(WEEKDAY([Start Date],2)=2,[Start Date]+7,IF(WEEKDAY([Start Date],2)=3,[Start Date]+7,IF(WEEKDAY([Start Date],2)=4,[Start Date]+7,IF(WEEKDAY([Start Date],2)=5,[Start Date]+7,IF(WEEKDAY([Start Date],2)=6,[Start Date]+9,IF(WEEKDAY([Start Date],2)=7,[Start Date]+8,0))))))),IF([Task Recurrance]="Monthly",IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0))))))),IF([Task Recurrance]="Quarterly",IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0))))))),IF([Task Recurrance]="Bi-annually",IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0))))))),IF([Task Recurrance]="Annually",IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0)))))))))))
= IF([任务重复发生次数] =每日"，IF(WEEKDAY([开始日期]，2)= 1，[开始日期] + 1，IF(WEEKDAY([开始日期]，2)= 2，[开始日期] + 1，IF(WEEKDAY([开始日期]，2)= 3，[开始日期] + 1，IF(WEEKDAY([开始日期]，2)= 4，[开始日期] + 1，IF(WEEKDAY ([开始日期]，2)= 5，[开始
日期] + 3，IF(WEEKDAY([开始日期]，2)= 6，[开始日期] + 2，IF(WEEKDAY([开始日期]，2)= 7，[开始日期] +1,0)) )))))，IF([任务重复发生次数] =每周"，IF(WEEKDAY([开始日期]，2)= 1，[开始日期] + 7，IF(WEEKDAY([开始日期]，2) = 2，[开始日期] + 7，IF(WEEKDAY([开始
日期]，2)= 3，[开始日期] + 7，IF(WEEKDAY([开始日期]，2)= 4，[开始日期] + 7，IF(WEEKDAY([开始日期]，2)= 5， [开始日期] + 7，IF(WEEKDAY([开始日期]，2)= 6，[开始日期] + 9，IF(WEEKDAY([开始日期]，2)= 7，[开始日期] +8,0 ))))))))，IF([任务重复发生次数] =每月"，IF(WEEKDAY(DATE(YEAR([开始
日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 1，CONCATENATE(文本(DATE(YEAR([开始日期]))，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，"，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE (YEAR([开始日期])，MONTH([开始
日期])+ 1，DAY([开始日期]))，2)= 2，CONCATENATE(文本(日期(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期] ))，"d/MM/yyyy")，，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])) ，MONTH([开始日期])+ 1，DAY([开始
Date]))，2)= 3，CONCATENATE(TEXT(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy" ;)，"，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1 ，DAY([开始日期]))，2)= 4，CONCATENATE(TEXT(DATE(YEAR([开始
日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 5，CONCATENATE(TEXT(DATE(YEAR([开始日期]))，MONTH([开始
日期])+ 1，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]])，2)= 6，CONCATENATE(TEXT(DATE(YEAR([开始日期]])，MONTH([开始日期])+ 1，DAY([开始
日期])+ 2)，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 7，CONCATENATE(TEXT(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始
日期])+ 1)，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，0))))))))))))))))，IF() ([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 1，CONCATENATE(TEXT(DATE(YEAR([开始
日期])，MONTH([开始日期])+ 3，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]])，2)= 2，CONCATENATE(TEXT(DATE(YEAR([开始日期]))，MONTH([开始
日期])+ 3，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 3，CONCATENATE(文本(日期(YEAR([开始日期])，MONTH([开始日期])+ 3，DAY([开始
日期])，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 4，CONCATENATE(文本(日期(YEAR([开始日期])，MONTH([开始日期])+ 3，DAY([开始日期]))，"d/MM/yyyy" ;)".
" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 5，CONCATENATE(文本(日期(YEAR([开始日期])，MONTH([开始日期])+ 3，DAY([开始日期]))，"d/MM/yyyy" ;)，" TEXT([开始
日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期]]，MONTH([开始日期])+ 1，DAY([开始日期]))，2) = 6，CONCATENATE(TEXT(DATE(YEAR([开始日期]])，MONTH([开始日期])+ 3，DAY([开始日期])+ 2)，"d/MM/yyyy")，"； "，TEXT([开始
日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期]]，MONTH([开始日期])+ 1，DAY([开始日期]))，2) = 7，CONCATENATE(TEXT(DATE(YEAR([开始日期]])，MONTH([开始日期])+ 3，DAY([开始日期])+ 1)，"d/MM/yyyy")，"； "，TEXT([开始
日期]，"hh:mm AM/PM"))，0))))))))))，IF([任务重复执行次数] =每年两次"，IF(WEEKDAY(DATE(YEAR([开始日期]) )，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 1，CONCATENATE(文本(DATE(YEAR([开始日期]))，MONTH([开始日期])+ 6， DAY([开始日期]))，"d/MM/yyyy")，
" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始日期])+ 1，DAY([开始Date]))，2)= 2，CONCATENATE(TEXT(DATE(YEAR([开始日期])，MONTH([开始日期])+ 6，DAY([开始日期]))，"d/MM/yyyy" ;)，" TEXT([开始
日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期]]，MONTH([开始日期])+ 1，DAY([开始日期]))，2) ＝ 6，CONCATENATE(TEXT(DATE(YEAR([开始日期])，MONTH([开始日期])+ 6，DAY([开始日期]))，"d/MM/yyyy")，" ，TEXT([开始日期]，"hh:mm
AM/PM))，IF(WEEKDAY(DATE(YEAR([开始日期]))，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 4，CONCATENATE(TEXT(DATE (YEAR([开始日期])，MONTH([开始日期])+ 6，DAY([开始日期]))，"d/MM/yyyy")，"，TEXT([开始日期]， "hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([Start
日期])，MONTH([开始日期])+ 1，DAY([开始日期]))，2)= 5，CONCATENATE(TEXT(DATE(YEAR([开始日期]))，MONTH([开始日期])+ 6，DAY([开始日期]))，"d/MM/yyyy")，，TEXT([开始日期]，" hh:mm AM/PM))，IF(WEEKDAY(DATE (YEAR([开始日期])，MONTH([开始
日期])+ 1，DAY([开始日期]))，2)= 6，CONCATENATE(TEXT(日期(YEAR([开始日期])，MONTH([开始日期])+ 6，DAY([开始日期] )+2)，"d/MM/yyyy")，，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])，MONTH([开始
日期])+ 1，DAY([开始日期]))，2)= 7，CONCATENATE(TEXT(日期(YEAR([开始日期])，MONTH([开始日期])+ 6，DAY([开始日期] )+1)，"d/MM/yyyy")，，TEXT([开始日期]，"hh:mm AM/PM"))，0)))))))))))))) [任务重复发生次数] =每年"，IF(WEEKDAY(DATE(YEAR([开始
日期])+ 1，MONTH([开始日期])，DAY([开始日期]))，2)= 1，CONCATENATE(文本(DATE(YEAR([开始日期]])+ 1，MONTH([开始日期] )，DAY([开始日期]))，"d/MM/yyyy")，"，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE (YEAR([开始日期])+ 1，MONTH([开始
Date])，DAY([Start Date]))，2)= 2，CONCATENATE(TEXT(DATE(YEAR([Start Date]] + 1)，MONTH([Start Date])，DAY([Start Date]))) ，"d/MM/yyyy")，"TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期]))+ 1 ，MONTH([开始日期])，DAY([开始
日期]))，2)= 3，CONCATENATE(文本(日期(YEAR([开始日期])+ 1，月份([开始日期])，日期([开始日期]))，"d/MM/yyyy" ;)，"，TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])+ 1，MONTH([开始日期]) ，DAY([开始日期]))，2)= 4，CONCATENATE(TEXT(DATE(YEAR([开始
日期])+ 1，MONTH([开始日期])，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])+ 1，MONTH([开始日期])，DAY([开始日期]])，2)= 5，CONCATENATE(TEXT(DATE(YEAR([开始日期])+ 1，MONTH([开始
日期])，DAY([开始日期]))，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])+ 1，MONTH([开始日期])，DAY([开始日期]])，2)= 6，CONCATENATE(TEXT(DATE(YEAR([开始日期]] + 1)，MONTH([开始日期])，DAY([开始
日期])+ 2)，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，IF(WEEKDAY(DATE(YEAR([开始日期])+ 1，MONTH([开始日期])，DAY([开始日期]])，2)= 7，CONCATENATE(TEXT(DATE(YEAR([开始日期]] + 1)，MONTH([开始日期])，DAY([开始
日期])+ 1)，"d/MM/yyyy")，"" TEXT([开始日期]，"hh:mm AM/PM"))，0))))))))))))))))))))
=IF([Task Recurrance]="Daily",IF(WEEKDAY([Start Date],2)=1,[Start Date]+1,IF(WEEKDAY([Start Date],2)=2,[Start Date]+1,IF(WEEKDAY([Start Date],2)=3,[Start Date]+1,IF(WEEKDAY([Start Date],2)=4,[Start Date]+1,IF(WEEKDAY([Start Date],2)=5,[Start
Date]+3,IF(WEEKDAY([Start Date],2)=6,[Start Date]+2,IF(WEEKDAY([Start Date],2)=7,[Start Date]+1,0))))))),IF([Task Recurrance]="Weekly",IF(WEEKDAY([Start Date],2)=1,[Start Date]+7,IF(WEEKDAY([Start Date],2)=2,[Start Date]+7,IF(WEEKDAY([Start
Date],2)=3,[Start Date]+7,IF(WEEKDAY([Start Date],2)=4,[Start Date]+7,IF(WEEKDAY([Start Date],2)=5,[Start Date]+7,IF(WEEKDAY([Start Date],2)=6,[Start Date]+9,IF(WEEKDAY([Start Date],2)=7,[Start Date]+8,0))))))),IF([Task Recurrance]="Monthly",IF(WEEKDAY(DATE(YEAR([Start
Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start
Date])+1,DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start
Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start
Date]),MONTH([Start Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start
Date])+1,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start
Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start
Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0))))))),IF([Task Recurrance]="Quarterly",IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start
Date]),MONTH([Start Date])+3,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start
Date])+3,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start
Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])),"d/MM/yyyy"),"
",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start
Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])+2),"d/MM/yyyy")," ",TEXT([Start
Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+3,DAY([Start Date])+1),"d/MM/yyyy")," ",TEXT([Start
Date],"hh:mm AM/PM")),0))))))),IF([Task Recurrance]="Bi-annually",IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy"),"
",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start
Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm
AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start
Date]),MONTH([Start Date])+1,DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start
Date])+1,DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date]),MONTH([Start
Date])+1,DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date]),MONTH([Start Date])+6,DAY([Start Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0))))))),IF([Task Recurrance]="Annually",IF(WEEKDAY(DATE(YEAR([Start
Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=1,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start
Date]),DAY([Start Date])),2)=2,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start
Date])),2)=3,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=4,CONCATENATE(TEXT(DATE(YEAR([Start
Date])+1,MONTH([Start Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=5,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start
Date]),DAY([Start Date])),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=6,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start
Date])+2),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),IF(WEEKDAY(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start Date])),2)=7,CONCATENATE(TEXT(DATE(YEAR([Start Date])+1,MONTH([Start Date]),DAY([Start
Date])+1),"d/MM/yyyy")," ",TEXT([Start Date],"hh:mm AM/PM")),0)))))))))))
推荐答案
您好kelsnz，
Hi kelsnz,
计算列的最大限制为255个字符.
There is a max limit of 255 characters for a calculated column.
计算列太长.
有关计算列的更多信息，您可以参考:
More information about calculated column, you can refer to:
https://technet.microsoft.com/en-us/library/cc262787.aspx #Column
谢谢
温迪
这篇关于计算列-长度有限制吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
