Formula to split a period in weeks

[CHRISTOPHE_CHAN]

Hi, 

I am looking for a bunch of formulas to split a montlhy period in weeks. Like :

Col1 : 1st day of the month -> manually entered

Col2 : last day of the month -> manually entered

Col3 : 1st sunday of the month

Col4 : the day after Col3

Col5 : 2nd sunday of the month

Col6 : the day after Col5

Col7 : 3nd sunday of the month

Col8: the day after Col7

Col9 : 4th sunday of the month

Col10: the day after Col9

Col11 : 5th sunday of the month

Col12 : the day after Col11

Any suggestion ?

Thanks 

Chris

[Marc_Dillon]

No idea what you're asking, but this should help:

https://help.appsheet.com/en/articles/961346-date-and-time-expressions

[Joseph_Seddik · Accepted solution]

• Col3  : [Col1] + MOD(8 - WEEKDAY([Col1]), 7)
• Col4  : [Col3] + 1
• Col5  : [Col3] + 7
• Col6  : [Col5] + 1
• Col7  : [Col5] + 7
• Col8  : [Col7] + 1
• Col9  : [Col7] + 7
• Col10 : [Col9] + 1

[CHRISTOPHE_CHAN]

Thanks for your suggestion ! I dealt with it