Calendar Adding Dates to a Specific Number like - like df(dd) + df(f)?

[binoyanto]

Hi ,

I am creating a 2 week calendar using simple text, I would like to find the First week Day as sunday, and we have Friday , Saturday as Off. Gets Weeks starting date in GV by formula - df(dd)-df(f). Present Date - Index of Week day (ISO)
Now I need to get the full week Days by Adding Week Day Index like ,0,1,2,3,4,5,6 to generate the numbers, How this can be done in date format? Any help appreciated.
Sample attached

[CharlesBeach]

2-week calendars seem popular at the moment.

I just posted my version, but it’s hard set to start weeks on Monday. There might be useful formulas in it though:

Multi Line Calendar Komponent

I made this in KLWP, but I think it should work in KWGT too… The tutorial I used before, by Erik Bucik, has a few formula errors in it, which were hard to diagnose, so I simplified it quite a bit. Erik’s tutorial: I’ve not literally copied but definitely inspired by Erik’s good work. Notes: There’s a bug with df(e) so this Komponent is manually hard coded with weeks starting on Monday You can add or remove Week rows and Event rows, to have more or fewer of those parts. Just copy and paste…

I think you’re trying to increment the date (number) for each day.

The trick Eric Bucik based his tutorial on was using mindex, which requires a structure of Weeks; Week; Day:

Group (“weeks”)
– Group (“week”)
– Group (“week”)
---- Group (“day”)
------ text

Then you can use a formula to increment the date numbers - (si(mindex, 1)+(si(mindex, 2)*7)