LinkBack URL
About LinkBacks
your EOWEEK formulas have a right parenthesis wronly placed.
here is the first formula corrected and working:
=IF(AND(INDEX(Q2:Q27,MATCH(C6,P2:P27,0))="EOWEEK",6-WEEKDAY(C4)>=1),C4+6-WEEKDAY(C4),"")
your EOWEEK formulas have a right parenthesis wronly placed.
here is the first formula corrected and working:
=IF(AND(INDEX(Q2:Q27,MATCH(C6,P2:P27,0))="EOWEEK",6-WEEKDAY(C4)>=1),C4+6-WEEKDAY(C4),"")
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks