Help in excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1423174%22%20slang%3D%22en-US%22%3EHelp%20in%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423174%22%20slang%3D%22en-US%22%3EGood%20morning%3CBR%20%2F%3EIf%20i%20want%20to%20write%20specfic%20word%20and%20when%20i%20write%20it..%20the%20next%20column%20will%20give%20me%20the%20date%20of%20today%3CBR%20%2F%3EExample%3CBR%20%2F%3EColumn%20A%20...%20Column%20B%3CBR%20%2F%3EHi%20...%2028%2F5%2F2020%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1423174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423205%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20in%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F681978%22%20target%3D%22_blank%22%3E%40Mamoud33%3C%2FA%3E%26nbsp%3BSomething%20like%20this%20perhaps%3F%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(A1%3D%22xxxxxx%22%2CTODAY()%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Ewhere%20%22xxxxxx%22%20contains%20the%20word%20you%20want%20to%20trigger%20today's%20date%20with.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423389%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20in%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423389%22%20slang%3D%22en-US%22%3EHello%20you%20gave%20me%20formula%20with%20specfic%20date%20to%20add..i%20want%20the%20date%20automaticlly%20take%20the%20day%20i%20am%20in..%20thank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423403%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20in%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F681978%22%20target%3D%22_blank%22%3E%40Mamoud33%3C%2FA%3E%26nbsp%3BSorry%2C%20don't%20follow%20that.%20TODAY()%20gives%20you%20today's%20date.%20If%20that's%20not%20what%20you%20want%2C%20please%20clarify.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423421%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20in%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423421%22%20slang%3D%22en-US%22%3EClearly..%3CBR%20%2F%3EI%20want%20if%20i%20put%20a%20specfic%20word%20in%20colomn%20A%20row1%20..%20Excel%20automatically%20write%20the%20date%20of%20any%20day%20i%20am%20in%20automatically%20in%20collum%20B%20row%201%3CBR%20%2F%3EHope%20it%20is%20clear%20enough..thank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423457%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20in%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F681978%22%20target%3D%22_blank%22%3E%40Mamoud33%3C%2FA%3E%26nbsp%3BClear%20as%20mud!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22%3CSPAN%3Eautomatically%20write%20the%20date%20of%20any%20day%20i%20am%20in%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWhat%20day%20are%20you%20%3CSTRONG%3Ein%3C%2FSTRONG%3E%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Good morning
If i want to write specfic word and when i write it.. the next column will give me the date of today
Example
Column A ... Column B
Hi ... 28/5/2020
5 Replies
Highlighted

@Mamoud33 Something like this perhaps?

=IF(A1="xxxxxx",TODAY(),"")

where "xxxxxx" contains the word you want to trigger today's date with. 

Highlighted
Hello you gave me formula with specfic date to add..i want the date automaticlly take the day i am in.. thank you
Highlighted

@Mamoud33 Sorry, don't follow that. TODAY() gives you today's date. If that's not what you want, please clarify.

Highlighted
Clearly..
I want if i put a specfic word in colomn A row1 .. Excel automatically write the date of any day i am in automatically in collum B row 1
Hope it is clear enough..thank you
Highlighted

@Mamoud33 Clear as mud!

 

"automatically write the date of any day i am in"

 

What day are you in?