Advertisement
Guest User

Getting an err504. Not seeing it.

a guest
May 10th, 2019
170
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =IF(H3="","",IF((SUM(WEEKNUM((H3),21)-3))>9,VALUE(YEAR(H3))&SUM(WEEKNUM((H3),21)-3)),IF((SUM(WEEKNUM((H3),21)-3))>3,VALUE(YEAR(H3)&0&SUM(WEEKNUM((H3),21)-3)),VALUE(SUM(YEAR(H3)-1)&0&IF(H3=3,52,IF(H3=2,51,50)))))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement