Home

Auto insert a Static date

%3CLINGO-SUB%20id%3D%22lingo-sub-707651%22%20slang%3D%22en-US%22%3EAuto%20insert%20a%20Static%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-707651%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20wondering%20if%20there%20is%20a%20way%20to%20automatically%20insert%20the%20static%20date%20in%20a%20worksheet%20if%20value%20is%20entered%20in%20another%20cell.%3C%2FP%3E%3CP%3EExample%2Freason.%3C%2FP%3E%3CP%3EI%20have%20a%20UAT%20testing%20log%2C%20and%20when%20the%20customer%20selects%20%E2%80%98Complete%E2%80%99%20from%20a%20dropdown%2C%20(in%20cell%20I4)%2C%20then%20I%20want%20the%20static%20date%20to%20be%20populated%20into%20another%20cell%20(O4)%20to%20show%20and%20record%20the%20date%20the%20action%20was%20completed.%3C%2FP%3E%3CP%3EAny%20advice%20most%20welcome.%3C%2FP%3E%3CP%3EMuch%20Obliged%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-707651%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-707702%22%20slang%3D%22en-US%22%3ERe%3A%20Auto%20insert%20a%20Static%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-707702%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F363003%22%20target%3D%22_blank%22%3E%40AJW77%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20my%20knowledge%20there%20are%20two%20ways%20-%20use%20some%20VBA%20programming%3B%20or%20formula%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20214px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119754i4296CC2D0510DB6C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3DIF(A1%26lt%3B%26gt%3B%22%22%2C%20IF(B1%3D%22%22%2CNOW()%2C%20B1)%2C%20%22%22)%3C%2FPRE%3E%0A%3CP%3Ebut%20the%20latest%20requires%20that%20iterative%20calculations%20to%20be%20swithed%20on%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20722px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119755iB43EED1582CFD367%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewhat%20could%20have%20a%20negative%20side%20effect.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
AJW77
Occasional Visitor

I was wondering if there is a way to automatically insert the static date in a worksheet if value is entered in another cell.

Example/reason.

I have a UAT testing log, and when the customer selects ‘Complete’ from a dropdown, (in cell I4), then I want the static date to be populated into another cell (O4) to show and record the date the action was completed.

Any advice most welcome.

Much Obliged

1 Reply

@AJW77 

 

To my knowledge there are two ways - use some VBA programming; or formula like this

image.png

=IF(A1<>"", IF(B1="",NOW(), B1), "")

but the latest requires that iterative calculations to be swithed on

image.png

what could have a negative side effect.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies