Weekend on Sunday (Mo - Sunday week)

1

Hi Dmitry

I want to get the weekend of a date. The weekend must be a Sunday
(Week Monday - Sunday)

I am using the following formula:
Weekend = weekend([Position Hire Date])+1

It does not provide me with the correct results if the date falls on a Sunday:

15/8/21 = Sunday, I expected weekend to be 15/8/21 but is shows as 21/8/21

Any suggestions?

Thanks

Rykie

2

Hi Rykie,

It seems that the following formula should give you the expected result:

weekend([Position Hire Date]-1)+1

1 Like
3

Thank you, Andrew