bi-weekly formula help needed

[Brad1]

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 solution]

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

[Brad1]

I changed the formula to this abs(ceil(DateTimeDiff([start date],DateTimeToday(),'days')/7))

and will only use one Start Date from the Input and won't need a grid of future dates.

It works.  Thanks.

[joelmiller66 · Accepted solution]

@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]

This my altered answer from Carli.  Thanks everyone.  I now have a bi-weekly scheduled WF.  I join in results with a hard-coded 'Y' and results either make to the end of the WF and get emailed or the don't.

[Brad1 · Accepted solution]

Dynamic Bi-Weekly Schedule example.