See if this will get you heading in the right direction. The formula below will find the date and to the test for you, you just need to finish it off with the ABC part....
=VLOOKUP($B$1,'Pay Calendars'!$A$2:$C$27,3,0)<=DATE(2014,MONTH($B$3),DAY($B$3))+3
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks