LinkBack URL
About LinkBacks
Try
=IF(AND(D$1+0>=YEAR($B2),D$1+0<=YEAR($C2)),$A2/(YEAR($C2)-YEAR($B2)+1),0)
Headers in TABLES are always TEXT so you cannot compare with a Excel date; the D$1+0 converts the header text to a numeric value
Try
=IF(AND(D$1+0>=YEAR($B2),D$1+0<=YEAR($C2)),$A2/(YEAR($C2)-YEAR($B2)+1),0)
Headers in TABLES are always TEXT so you cannot compare with a Excel date; the D$1+0 converts the header text to a numeric value
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks