calculate date between today

[salehaljoei]

Hello guys,

I have a date column

I want to count the number of days without Friday and Saturday

from the [date] to TODAY()

thanks

[Tommy62]

Leider gib es nur einen einfachen Ausdruck für ohne Samstag und Sonntag, daher nehme ich für diese Lösungen den Ansatz, einer zusätzlichen Tabelle der Wochentage, wie in dieser Vorlage-App in diesem Thread: Soll-Workday-Rechner    

[Sirfyaad]

To count the number of days without Friday and Saturday from the [date] to today using AppSheet expressions, you can use the following formula:- 

COUNT(
SELECT(
DatesTable[date],
AND(
[date] >= (TODAY() - WEEKDAY(TODAY()) + 1),
[date] <= TODAY(),
NOT(IN(WEEKDAY([date]), {6, 7}))
)
)
)

[Gustavo_Eduardo · Accepted solution]

Dear friend, here is a solution created by @Joseph_Seddik, a genius from the community. he has created an app that you can review that allows you to choose the non-working day. My problem is that I have requested a function that allows me to decide which day was working or not, however I could not find it. WORKDAY() only covers Saturdays and Sundays. This solution allows you to choose non-working days and holidays.

Post Link:

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Target-Workday-Calculator/m-p/405596#M6021

App Link:

https://www.appsheet.com/templates?appGuidString=42499ab7-491c-43e1-b338-17cd6a126855

I hope this solution helps you

[salehaljoei]

thanks its worked