Dynamic Calendar fixing VLOOKUP error for cells without information
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!
Last edited by cheeseleweese; 01-12-2021 at 06:22 PM.
Re: Dynamic Calendar fixing VLOOKUP error for cells without information
Hey, I'll try to help.
The problem is that 0, when you format on day, its 00/01/1900.
So what we need is to read that the day is empty, and turn it in some information.
I added an IF case on the formula, checking if it was different from zero, and when false, returning the wording MISSING.
This does not seam to break anything else in your work, however, I added a IFERROR in the "estimated time", just to keep it as clean as the other columns.