HI
I have a solution I want to write a script or calculation  that counts one day a week as vacation for 1 year,  from a specific day forward.

example .. every sunday until 2024

 

Could you be more specific with your requirements? Counting weeks is not the same thing as counting Sundays. What are the inputs to this calculation and what are the exact rules - esp. with regards to partial weeks?

 

Edited November 18, 20223 yr by comment

Thanks for your answer , here is  a solution you can work with.

This solution is similar to my original.
If you check record 15, Erik has permission from. 2022-11-13 until 2022-11-27
if you add a new record with date/time it will be green until the end date 2022-11-27
I want a secript for permission where a person can have every Monday off, e.g. until the year 2023 and the field perm shows green

 

fpattandance.fmp12

Sorry, I have no idea what you mean.

Edited November 20, 20223 yr by comment

Here you can find a calculation that allows you to count how many Mondays (or any other day of week) are in a given range:
https://fmforums.com/topic/42435-of-fridays-in-a-given-time-period/?do=findComment&comment=197966&_rid=72594

Here is a custom function that returns a list of those days:
https://www.briandunning.com/cf/452

If neither of these answer your question, you will have to be much more specific.

 

 

 

 

Edited November 21, 20223 yr by comment