This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How can I compute the number of delay([age]), today vs [date_gl] but excluding sunday as additional day for delay or aging

Posted on 11-16-2021 09:47 PM
Audit_CKGoC
Bronze 5
Bronze 5
Reply posted on --/--/---- --:-- AM

3X_6_1_61a6322d911f086bb69650077c436ac0eacab1c3.png

0 3 126
Topic Labels
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

Are we supposed to understand this?

Posted on --/--/---- --:-- AM
Audit_CKGoC
Bronze 5
Bronze 5
In response to Steve
Reply posted on --/--/---- --:-- AM

[How can I compute the number of delay([age]), today vs [date_gl] but excluding sunday as additional day for delay or aging]

0 Likes

Posted on --/--/---- --:-- AM
Aurelien
Google Developer Expert
Google Developer Expert
In response to Audit_CKGoC
Reply posted on --/--/---- --:-- AM

Hi @Audit_CKGoC

That may help you:

The rest of it is pure math, in my opinion.
Maybe something like:

TOTALHOURS([Date2] - [Date1]) / 24
-
(TOTALHOURS([Date2] - [Date1]) / 24)/7

(2nd part: count how many weeks, thus sundays, have been in the timeslot)

Top Labels in this Space