فرمول تقویم شمسی در M.S.P

چاپ

تاریخ ایجاد در دوشنبه, 09 اسفند 1395

تاریخ شروع ثبت فرمول ذیل در ستون TEXT 01

(Int((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00"))-Int(Int([Scheduled Start]-DateValue("21/3/1997 00:00:00"))/1461))/365)+76) & "/" & (IIf(((((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))<=186;Int(((((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))/31)+1;Int((((((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))-186)/30)+7)) & "/" & (IIf(((((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))<=186;Int(((((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365)) Mod 31)+1;Int((((((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))-186) Mod 30)+1+(IIf((Int([Scheduled Start]-DateValue("21/3/1997 00:00:00"))) Mod 1461=0;1;0))))

تاریخ پایان ثبت فرمول ذیل در ستون TEXT 02

(Int((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00"))-Int(Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00"))/1461))/365)+76) & "/" & (IIf(((((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))<=186;Int(((((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))/31)+1;Int((((((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))-186)/30)+7)) & "/" & (IIf(((((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))<=186;Int(((((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365)) Mod 31)+1;Int((((((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))-Int((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00")))/1461)) Mod 365))-186) Mod 30)+1+(IIf((Int([Scheduled Finish]-DateValue("21/3/1997 00:00:00"))) Mod 1461=0;1;0))))