Link to home
Start Free TrialLog in
Avatar of Mandy_
Mandy_

asked on

Excel insert date and text in formula

How can i add the current date before the result of the formula below and a short text like "text" behind?

=INDIREKT("sheet1!$c$"&$A$1)


Thanks in advance
Avatar of Naresh Patel
Naresh Patel
Flag of India image

=today()&INDIREKT("sheet1!$c$"&$A$1)&"text"


Thanks
ASKER CERTIFIED SOLUTION
Avatar of Naresh Patel
Naresh Patel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mandy_
Mandy_

ASKER

thank you so much