Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =DATE( YEAR(SomeDate),MONTH(SomeDate),1 )
- + 2 - WEEKDAY( DATE( YEAR(SomeDate),MONTH(SomeDate),1 ) )
- + 14
- + IF( WEEKDAY( DATE( YEAR(SomeDate),MONTH(SomeDate),1 ) ) > 2, 7, 0)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement