bi-weekly formula help needed

Question

Hi,

I'm needing a formula that can determine if an even number of weeks have passed since a given date.  In other words StartDate = 2022-10-14.  That is a Friday.  When the WF runs I need a 'Y' if run at two weeks and four weeks etc. and a 'N' on all other days.

This is needed because the scheduler can't do every other Friday.

Thanks in advance for any help.

CarliE · Accepted Answer

Hi @Brad1 ,

You can use a formula to get the difference in weeks between the start date and the date and then use a formula to say if its even or odd.

Does this help to solve your problem? If so, please be sure to mark it as a solution

joelmiller66 · Accepted Answer

@Brad1 You also can also identify the week number for the calendar year by using the specifier %W.

This will make it easier to get the difference calculation.

Example: DateTimeFormat([Date],"%W")

Brad1 · Accepted Answer

Dynamic Bi-Weekly Schedule example.