Apr 06 2021 01:51 PM - edited Apr 07 2021 07:11 AM
=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 once the End Date is entered it would true it up to that date.
Apr 07 2021 07:00 AM
May I suggest that you attach not an image but a copy of the actual spreadsheet? Just so long as it includes no confidential information.
Apr 07 2021 07:04 AM
@mathetes I have attached it now. Thank you.
Apr 07 2021 07:10 AM
I recognized nothing on the screenshot, in general that could be like
=IF(EndDate="", "", EndDate - StartDate)
Apr 07 2021 07:12 AM
Apr 07 2021 08:00 AM