# Get Sunday occurences from a timeline column

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.

t

Thank you,

Corentin

@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

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

Update : I suceeded to implement te formula

Thanks a lot anyway !

Corentin

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