to enter a static date

[mazhar545]

Hi how to insert a static date in a cell when another cell is filled (if function)

[#2]

@mazhar545 

If without VBA that's as here https://chandoo.org/wp/timestamps-excel-formula-help/

[#3]

@Sergei Baklan 

thanks

and how with VBA ?

[#4]

@mazhar545 

For example https://www.exceltip.com/date-time-in-vba/insert-date-time-stamp-with-vba.html But I'd suggest you to ask google - lot of such samples and you could find one which is more suitable for your concrete project.