Calculate any Date

FlexiQ Date Calculate Formule

Formule:

2018, 28 May:

(2018 – 1 x 365) + (total of leap year days 2018 /4 = 504) + (*April + 28) = 736857 /7

105265,285714 – 105265 = 0, 285714

0, 285714 x 7 = 2

**2 Monday

2029, 7 June:

(2029 – 1 x 365) + (total of leaps year days 2029 /4 = 507) + (*May + 7) = 740885 /7

105840,714285 – 105840 = 0,714285

0,714285 x 7 = 5

**5 Thursday

*Month Table (-1 month + total days of the calculated month)

January 1-31

February 59

March 90

April 120

May 151

June 181

July 212

August 243

September 274

October 304

November 335

Desember 365

**Weekdays table

0 = Saturday

1 = Sunday

2 = Monday

3 = Tuesday

4 = Wednesday

5 = Thursday

6 = Friday