You are viewing limited content. For full access, please sign in.

Question

Question

How to calculate Fridays count between two dates in form

Forms
Updated February 6, 2021
asked on February 5, 2021

I want total count of particular day between two dates For example: If i have start date and end date then need to return total count of days without fridays between these dates.

0 0

Answer

SELECTED ANSWER
replied on February 6, 2021

Hi Mahmoud,

You can calculate Fridays count between two dates by calculating difference between the WEEKNUM (Friday mode) of them. Please check description of the function in https://doc.laserfiche.com/laserfiche.documentation/english/docs/Default.htm#../Subsystems/ProcessAutomation/Content/Forms-Current/Formulas.htm#Date/Tim
For example, =WEEKNUM(EndDate,15)-WEEKNUM(StartDate,15) will return the Fridays in between, and =EndDate-StartDate-(WEEKNUM(EndDate,15)-WEEKNUM(StartDate,15)) is count of days without Fridays in between.

2 0
replied on February 6, 2021

Thanks so much. You've been a great help.smiley

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...