to enter a static date

%3CLINGO-SUB%20id%3D%22lingo-sub-1506805%22%20slang%3D%22en-US%22%3Eto%20enter%20a%20static%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506805%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20how%20to%20insert%20a%20static%20date%20in%20a%20cell%20when%20another%20cell%20is%20filled%20(if%20function)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1506805%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1507057%22%20slang%3D%22en-US%22%3ERe%3A%20to%20enter%20a%20static%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1507057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721472%22%20target%3D%22_blank%22%3E%40mazhar545%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20without%20VBA%20that's%20as%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fchandoo.org%2Fwp%2Ftimestamps-excel-formula-help%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchandoo.org%2Fwp%2Ftimestamps-excel-formula-help%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1517040%22%20slang%3D%22en-US%22%3ERe%3A%20to%20enter%20a%20static%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1517040%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3Eand%20how%20with%20VBA%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1517353%22%20slang%3D%22en-US%22%3ERe%3A%20to%20enter%20a%20static%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1517353%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F721472%22%20target%3D%22_blank%22%3E%40mazhar545%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.exceltip.com%2Fdate-time-in-vba%2Finsert-date-time-stamp-with-vba.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.exceltip.com%2Fdate-time-in-vba%2Finsert-date-time-stamp-with-vba.html%3C%2FA%3E%26nbsp%3BBut%20I'd%20suggest%20you%20to%20ask%20google%20-%20lot%20of%20such%20samples%20and%20you%20could%20find%20one%20which%20is%20more%20suitable%20for%20your%20concrete%20project.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

3 Replies
Highlighted
Highlighted

@Sergei Baklan 

thanks

and how with VBA ?

 

Highlighted

@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.