To check out my YouTube channel visit: https://youtube.com/user/mgomezb1
LIKE AND SUBSCRIBE!!!
Until next post!
MG.-
Mariano Gomez, MVP
UpdateContext({cdt:Today()});
With( {rootdate: DateValue("01/01/1900")}, With( { mts: DateDiff( rootdate, cdt, Months ) - 1 }, DateAdd( rootdate, mts, Months ) ) )
DateAdd(cdt, -Day(cdt), Days)
With( {rootdate: DateValue("01/01/1900")}, With( { mts: DateDiff( rootdate, cdt, Months ) }, DateAdd( rootdate, mts, Months ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { mts: DateDiff( rootdate, cdt, Months ) + 1 }, With( { FirstNxtMonth: DateAdd( rootdate, mts, Months ) }, DateAdd( FirstNxtMonth, -1, Days ) ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { mts: DateDiff( rootdate, cdt, Months ) + 1 }, DateAdd( rootdate, mts, Months ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { mts: DateDiff( rootdate, cdt, Months ) + 2 }, With( { FirstNxtMonth: DateAdd( rootdate, mts, Months ) }, DateAdd( FirstNxtMonth, -1, Days ) ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { qtrs: DateDiff( rootdate, cdt, Quarters ) }, DateAdd( rootdate, qtrs - 1, Quarters ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { qrtr: DateDiff( rootdate, cdt, Quarters ) }, With( { NxtQrtr: DateAdd( rootdate, qrtr, Quarters ) }, DateAdd( NxtQrtr, -1, Days ) ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { qtrs: DateDiff( rootdate, cdt, Quarters ) }, DateAdd( rootdate, qtrs, Quarters ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { qrtr: DateDiff( rootdate, cdt, Quarters ) + 1 }, With( { NxtQrtr: DateAdd( rootdate, qrtr, Quarters ) }, DateAdd( NxtQrtr, -1, Days ) ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { qrtr: DateDiff( rootdate, cdt, Quarters ) + 1 }, With( { NxtQrtr: DateAdd( rootdate, qrtr, Quarters ) }, DateAdd( NxtQrtr, 0, Days ) ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { qrtr: DateDiff( rootdate, cdt, Quarters ) + 2 }, With( { NxtQrtr: DateAdd( rootdate, qrtr, Quarters ) }, DateAdd( NxtQrtr, -1, Days ) ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { diffval: DateDiff( rootdate, cdt, Days ), Offset: 1 - Weekday(cdt) }, DateAdd( cdt, Offset - 7, Days ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { diffval: DateDiff( rootdate, cdt, Days ), Offset: 1 - Weekday(cdt) }, DateAdd( cdt, Offset - 1, Days ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { diffval: DateDiff( rootdate, cdt, Days ), Offset: 1 - Weekday(cdt) }, DateAdd( cdt, Offset, Days ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { diffval: DateDiff( rootdate, cdt, Days ), Offset: 1 - Weekday(cdt) }, DateAdd( cdt, Offset + 6, Days ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { diffval: DateDiff( rootdate, cdt, Days ), Offset: 1 - Weekday(cdt) }, DateAdd( cdt, Offset + 7, Days ) ) )
With( {rootdate: DateValue("01/01/1900")}, With( { diffval: DateDiff( rootdate, cdt, Days ), Offset: 1 - Weekday(cdt) }, DateAdd( cdt, Offset + 13, Days ) ) )