Thank you for your reply; it's been very helpful.
Is there any way that the date won't be defined in the formula, but instead it will be defined by another cell value (for example date(a5)), since the reference to the date is what caused the problem from the begining?