LinkBack URL
About LinkBacks
I made all the dates relate to the year 2000, so the formula in C2 of the Data sheet is:
=IF(B2="","",INDEX('Star Sign'!$A$2:$A$14,MATCH(DATE(2000,MONTH(B2),DAY(B2)),'Star Sign'!$B$2:$B$14)))
Hope this helps.
Pete
I made all the dates relate to the year 2000, so the formula in C2 of the Data sheet is:
=IF(B2="","",INDEX('Star Sign'!$A$2:$A$14,MATCH(DATE(2000,MONTH(B2),DAY(B2)),'Star Sign'!$B$2:$B$14)))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks