Forum Discussion
Auto Populate Data based on Start & End Date
=IF(AND(K$2>=$G255,K$2<=$H255),$I255,"") With the current formula above, I have to enter the "End Date" in order for it to populate. I would like for it populate when the End Date is blank, then ...
First off, thank you both for taking a look at my formula and sheet. I believe I have figured out my formula. I basically add an IF AND to reflect when the end date is blank to populate across the sheet. Once the end date is entered, it trues up the cost to the end date of the item or equipment.
=IF(AND(K$2>=$G255,K$2<=$H255),$I255, IF(AND(K$2>=$G255, $H255=""),$I255,""))
=IF(AND(K$2>=$G255,K$2<=$H255),$I255, IF(AND(K$2>=$G255, $H255=""),$I255,""))