Calculate date based on current years week number and specific week day
Hi, Is there any way to, in a sharepoint list, calculate a date based on 2 columns containing (1)current years week number and (2)a specifik week day. Current year=2023 Column1: 28 Column2: Tis (Tuesday) The calculated date for current year would be 11072023 (DDMMYYY). This is for a planning tool, presented in powerapps, where a great deal of the events repeats every year. In order for me to highlight events in future I need a date. I was able to do it in PowerApps (calculate date based on said columns) but I have problem using/reaching that date more than presenting it, if I had that date in a column from the data source I thought it would be easier.
Training System
I created the training booking system using Sharepoint List with date selection. I wanted on each day, once the number of booking reached to 20 Message will appear that is session is full you can register the training other days. With limitation of Weekends. Any Validation formula, Presave JavaScript. Thanks In advance.Booking System - SharePoint
I created a Booking System using List of Sharepoint, the requirments are as follow Booking Date: This is set to select the desire Date but not today Date or Past Date "I added the Enforce unique values and add the Column validation for it =[Booking Date]>TODAY() with the message to appear as "The date entered cannot be today or in the past." Booking Time: This is set as (Dropdown List) Morning: 07:00am-03:00pm Evening: 04:00pm -11:30pm All day: 07:00am- 11:30pm Now the requirement is If someone wanted to book Lets say on 31-12-2021 can able to book Morning and if someone/Same Person wanted to book on same day evening time can be done but the Uniqe Value of booking date is the issue, it dont allow double booking and if i removed this uniqe value then many ppl can book at same Day and time. And if someone click one All Day even then no one can book Morning and Evening. If anyone knows how please support, Validation or Java Script. Kindly provide the full details im new to this please. Thanks Inadvance.