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 ...
I recognized nothing on the screenshot, in general that could be like
=IF(EndDate="", "", EndDate - StartDate)
- I have attached the file now to the post...sorry I thought I had.
