I am to write a formula that will move or update as the date of an item changes.
For example, if you have a payment that is do on 1/3/2017 for $100.00 in cells A1 & B1 respectively, I am using the formula =IF(AND(A1<=1/01/2017,A1>=1/7/2017),B1,0) but no values are calculating.
I've also tried =IF(AND(A1<=DATE(2017,1,1),A1>=DATE(2017,1,31)),B1,0) and again it doesn't give me the right calculation.
Thanks in advance!
Formula
=IF(AND(A1<=DATE(2017,1,1),A1>=DATE(2017,1,31)),B1,0)
Condition is A1 ashould be earlier to 1/1/17 simultaniously it should be after 31/1/17, which is not possible.
Try this
It may be like this
=IF(AND(A1>=DATE(2017,1,1),A1<=DATE(2017,1,31)),B1,0)
This formula puts the condition that A1 should be betweem 1/1/17 and 31/1/17.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks