Solved How to insert free text followed by a date formula

June 27, 2013 at 18:27:46
Specs: Windows XP
I would like to insert a title that says "Finstats as at: (last day of previous month)"

Is there a way to ibnsert free text right before formula =TODAY() or =NOW() ?

Thank you!


See More: How to insert free text followed by a date formula

Report •

✔ Best Answer
June 28, 2013 at 08:49:02
Sorry bout that, I could have sworn it worked for me when I posted,
but in trying it again it does not work for me either.

In your reply you used:

"Finstats as at 30 June41453"

What Date are you looking for to be appended to the string "Finstats as at:"
You have written in 30 June.

Are you looking for just the Year,
or are you looking for the Last Day of the previous month
or are you looking for the Last Day of the current month
or are you looking for something else?

The =TODAY() function returns todays date: June 28, 2013
The =NOW() function returns todays date and the current time: June 28, 2013 11:46

Not sure how those functions relate to what your looking for.

MIKE

http://www.skeptic.com/



#1
June 27, 2013 at 19:23:03
I'm going to assume you are talking about Excel.

Try

="Finstats as at: (last day of previous month)" & Today()

The Ampersand symbol is used to join the two parts of the formula,
the text string and the Date.

MIKE

http://www.skeptic.com/


Report •

#2
June 27, 2013 at 19:41:54
Hi Mike, thank you. I am using Excel 2003.

It doesn't seem to work, when I do what you suggested the cell reads

Finstats as at 30 June41453

Surely I am missing something.


Report •

#3
June 28, 2013 at 04:24:30
Try this...

="Finstats as at: 30 June"&" "&MONTH(TODAY())&"/"&DAY(TODAY())&"/"&YEAR(TODAY())

Since Excel considers the cell to be text, it is giving you the "text" representation of the date.

See here for an explanation of what the 41453 represents.

http://www.cpearson.com/excel/datet...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
June 28, 2013 at 08:49:02
✔ Best Answer
Sorry bout that, I could have sworn it worked for me when I posted,
but in trying it again it does not work for me either.

In your reply you used:

"Finstats as at 30 June41453"

What Date are you looking for to be appended to the string "Finstats as at:"
You have written in 30 June.

Are you looking for just the Year,
or are you looking for the Last Day of the previous month
or are you looking for the Last Day of the current month
or are you looking for something else?

The =TODAY() function returns todays date: June 28, 2013
The =NOW() function returns todays date and the current time: June 28, 2013 11:46

Not sure how those functions relate to what your looking for.

MIKE

http://www.skeptic.com/


Report •

#5
June 28, 2013 at 10:17:11
Here are three choices:

Last Day of Previous Month:

="Finstats as at: " & TEXT(EOMONTH(TODAY(),-1),"dddd dd mmm yyyy")

Last Day of Current Month:

="Finstats as at: " & TEXT(EOMONTH(TODAY(),0),"dddd dd mmm yyyy")

Last Day of Next Month:

="Finstats as at: " & TEXT(EOMONTH(TODAY(),1),"dddd dd mmm yyyy")

If your looking for the Last Workday of the Month,
the above will need to be tweaked.

Edit Added - TWEAKED

For the last Workday of the Previous Month:

="Finstats as at: " & TEXT(WORKDAY(EOMONTH(TODAY(),-1),0),"dddd dd mmm yyyy")

For the last Workday of the Current Month:

="Finstats as at: " & TEXT(WORKDAY(EOMONTH(TODAY(),0)+1,-1),"dddd dd mmm yyyy")


MIKE

http://www.skeptic.com/


Report •

#6
June 30, 2013 at 18:22:05
Thank you Mike,

What I needed to express was "Last Day of Previous Month". And your solution works perfectly.

="Finstats as at: " & TEXT(EOMONTH(TODAY(),-1),"dddd dd mmm yyyy")

Thank you so much!


Report •

Ask Question