LinkBack URL
About LinkBacks
Try in H9:
With G9 contains end date of month.
=INDEX(C$8:C$22,MATCH(MIN(ABS($G9-$B$8:$B$22)),ABS($G9-$B$8:$B$22),0))
Confirmed with Ctrl-Shift-Enter
Copy down and across.
Try in H9:
With G9 contains end date of month.=INDEX(C$8:C$22,MATCH(MIN(ABS($G9-$B$8:$B$22)),ABS($G9-$B$8:$B$22),0))
Confirmed with Ctrl-Shift-Enter
Copy down and across.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks