06-17-2022 17:01 PM - last edited 07-16-2022 07:40 AM
This Calendar has been created to use a single control as it's body, feel free to use this in your own apps.
It also automatically highlights Holidays on your calendar, using a formula in the fill to compare against a self generated list of the holidays for selected year (formulas for xth weekday day of each month created with American federal holidays, may need to adjust regionally)
You can also select a day day by clicking on it to highlight it blue, click it again to unselect it, and a control outside the calendar will display the selected day.
Control in top right will calculate if selected year is a leap year.
Hidden controls on left of screen will calculate working days (-weekends - holidays) between two dates, both counting and excluding first day
Calendars have been something I have been experimenting with for a very long time and wanted to share with others what I have working so far.
Would you mind adding a capture of your calendar components to your post so we can see how it looks when we view your post?
Is it possible to set this calendar to just show Monday to Friday, and exclude Saturday and Sunday altogether?
Yah you'd just need to set visibility of the controls to be false on saturdays and sundays. Then remove them from the header gallery