LinkBack URL
About LinkBacks
This formula places the values in the same cells as they were previously place (manually): =IF(ISTEXT(K3),"",IF(AND(K3>=DATE(YEAR(K3),MONTH(K3),$F4)-10,K3<=DATE(YEAR(K3),MONTH(K3),$F4)-7),$J4,""))
Let us know if you have any questions.
This formula places the values in the same cells as they were previously place (manually): =IF(ISTEXT(K3),"",IF(AND(K3>=DATE(YEAR(K3),MONTH(K3),$F4)-10,K3<=DATE(YEAR(K3),MONTH(K3),$F4)-7),$J4,""))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks