Hello! Another user helped me better organize the dynamic calendar I'm trying to make, however when there is a missing date in the purchase date column in the input data sheet a weird date pops up in the date for next purchase column in the predictor for future sheet and I want to find a way to make it write "Missing" or something along those lines. Also is there a way to reference the hours on previous years too by extracting dates from the input data so that it would pop up like in the example for 2019? Thank you for your help!
Bookmarks