Adding a formula into a statement

keiljohnsilver

New Member
Joined
Jan 21, 2017
Messages
6
Hi

I would like to input a date formula into the middle of a statement, i believe the concatenate formula can be used but i can't get the formula to work, any help pls
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,513
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
="something "&TEXT(NOW(),"ddd dd mmmm yyyy")&" something else"
 

keiljohnsilver

New Member
Joined
Jan 21, 2017
Messages
6
Hi

I would like to input a date formula into the middle of a statement, i believe the concatenate formula can be used but i can't get the formula to work, any help pls


can you elaborate on how to add the formula, the date is in another cell in date format, also what is "NOW"?
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,513
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
If you pasted that into a cell on your sheet you will see the result

Now() returns the date/time value for the system date.

you should be able to substitute Now() with your cell reference

The & is equivalent to concatenate and easier to spell
 

Watch MrExcel Video

Forum statistics

Threads
1,108,753
Messages
5,524,654
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top