LinkBack URL
About LinkBacks
Remove row 2
B3:
=A4
A4:
"1/1/2020"
A5:
=EDATE(A4,-12)
Copy to A9
A11:
=EDATE(A4,1)
A12:
=EDATE(A5,1)
Copy to A16
D4:
Copy to G,J,M,P
=IF(MONTH(A4)<>MONTH(A4+7),"",WORKDAY.INTL($A4-1,INT(COLUMNS($B:D)/3),"0111111"))
Copy B3:P9 to B10:P16
Remove row 2
B3:
=A4
A4:
"1/1/2020"
A5:
=EDATE(A4,-12)
Copy to A9
A11:
=EDATE(A4,1)
A12:
=EDATE(A5,1)
Copy to A16
D4:
Copy to G,J,M,P=IF(MONTH(A4)<>MONTH(A4+7),"",WORKDAY.INTL($A4-1,INT(COLUMNS($B:D)/3),"0111111"))
Copy B3:P9 to B10:P16
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks