How to apply Formula throughout the column by data validation without dragging the cell

Hi
I want to apply the below formula to the entire column. I donot want to drag or copy paste the cell. Can I do it by using Data validation option in excel.
=IFERROR(IF(L3>0,IF(K3>0,WORKDAY(K3,L3),""),""),"")

Thank you
Best regards

Yes I tried. But that increases the Excel size. Also I want to allow other to use the sheet. If I can apply through Data validation, the formula will be hidden and no need to protect sheet.

I may be wrong, but I think one can just open the data validation tab and clear all and that will erase all the parameters you set. I'm not thinking you can actually fill cells with the option, just kind of protect them. If anyone knows for sure though they'll be on this site. Sorry I couldn't help more.

If range is A1:A18, then select the range A1:A18
Data --> Data validation -->Settings--> Custom
Formula
=A1=(L3>0)*(K3>0)*WORKDAY(K3,L3)
Date is to be entered in the range manually.

Thank you, I tried to apply the formula through data validation, but seems its not working. I created a test data set. attached.
I put conditions so that if no value in receipt date and timeline fields, the due date remain blank.
Thanks for your help!

Is there any VBA code available for such scenario if not possible through DATA validation?

Data validation restricts the date entry. Only correct date can be entered as per formula.
TRy this.
Enter the formula in first cell. Get the fill handle. then double click. It fills formula for entire formula.

Sorry, I tried again. I even format the Date field. I applied the formula in first cell.
I used the test excel attached in previous post. =C2=(B2>0)*(A2>0)*WORKDAY(A2,B2)

Rather confused but If I understand correct;y ..applied DV to C2:C8

See attached.

Thank you. But when I change timeline in B2 or date in A2, the due date in C2 doesnt change. Seems the due date not automatically calculating. Any reason?