Re: Using a value from a cell inside a formula
Quote from NBVC;773034
Do you have an actual date in D1? I tested it and it works fine for me.
The formula you suggested works perfectly in excel but I am afraid the same doesn't work in google sheets which is quite surprising. I made sure that the format of both the ranges used in the formula is the same. Any solutions?