Hello all. My name is Jenny and this is my first time posting a problem.
I browsed through old posts, but did not find anything similar to my situation.
My Source file will feed into my Formula file (attached)
I need my formula to return blank when the dates from/to are not within those dates range.
For instance, 4/27 - 5/6, then my next set is 5/11 - 5/20. The gap in dates will be 5/7, 5/8, 5/9, and 5/10.
Since those dates are missing, I want the formula to return blank or n/a or something. Currently, the value returns with the previous row, column D.
Thank you for any help possible!!!! Have a great day.
Bookmarks