Get Sunday occurences from a timeline column

Platform discussions
,
1

Hello,

Is it possible to do a formula that is getting the number of Sundays in a timeline column ?

For example if I set a timeline from Thursday to Sunday, I would like to count 1 in the formula column as I have one Sunday.

image
image621×632 33.6 KB

t

Thank you,

Corentin

2

@corentin.dalfarra

This should do it for you:

ROUNDDOWN((("0" & DAYS({End Date}, {Start Date})) + 0) / 7, 0) + 
  IF(
    OR(
      AND(WEEKDAY({Start Date}) <= WEEKDAY({End Date}), WEEKDAY({Start Date}) <= 7, WEEKDAY({End Date}) >= 7), 
      AND(WEEKDAY({Start Date}) > WEEKDAY({End Date}), OR(WEEKDAY({Start Date}) <= 7, WEEKDAY({End Date}) >= 7))
    )
  , 1, 0)

To set a different day of the week, just change the last (not the first one) four "7"s to the day of the week you want to count. 1 = Monday, 7 = Sunday.

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: The ITEM ID column - What most people don’t know.
Contact me directly here: Contact – The Monday Man

3

Hi @JCorrell

Wow thank you very much it is very impressive ! I was not thinking we could do that.

Update : I suceeded to implement te formula :slight_smile:

Thanks a lot anyway !

Corentin

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.