Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 29th 08, 01:22 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 39
Default Format a date within a formula

I have table names that must have a 2 digit date at the end. I want to
automate a spreadsheet to use my tables names and put in the 2 digit date
using a formula.
A full, proper table name looks like this;

FAAA_2LOW_28

The 2 digit date is todays date and must be at the end with the underscore
preceding it. How can I put a formualted date in one cell, 7/28/08 using only
the 28, my table name in another cell, FAAA_2LOW, and then concatenate them
together as shown above? Everytime I try to do this the date ends up as
numbers.

Thanks in advance for any help.

  #2   Report Post  
Old July 29th 08, 01:42 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2008
Posts: 2,389
Default Format a date within a formula

Use the Text function, as in:

=A1&"_"&Text(a2,"dd")

Regards,
Fred.

"SJW_OST" wrote in message
...
I have table names that must have a 2 digit date at the end. I want to
automate a spreadsheet to use my tables names and put in the 2 digit date
using a formula.
A full, proper table name looks like this;

FAAA_2LOW_28

The 2 digit date is todays date and must be at the end with the underscore
preceding it. How can I put a formualted date in one cell, 7/28/08 using
only
the 28, my table name in another cell, FAAA_2LOW, and then concatenate
them
together as shown above? Everytime I try to do this the date ends up as
numbers.

Thanks in advance for any help.


  #3   Report Post  
Old July 29th 08, 01:49 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,942
Default Format a date within a formula

hi
try this
=A1&"_"&DAY(TODAY())
but if you have a date in a cell, say b1 then
=A1&"_"&DAy(B1))

regards
FSt1

"SJW_OST" wrote:

I have table names that must have a 2 digit date at the end. I want to
automate a spreadsheet to use my tables names and put in the 2 digit date
using a formula.
A full, proper table name looks like this;

FAAA_2LOW_28

The 2 digit date is todays date and must be at the end with the underscore
preceding it. How can I put a formualted date in one cell, 7/28/08 using only
the 28, my table name in another cell, FAAA_2LOW, and then concatenate them
together as shown above? Everytime I try to do this the date ends up as
numbers.

Thanks in advance for any help.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use a right formula on a date-format Heine Excel Worksheet Functions 4 December 21st 06 01:19 PM
Date format changes to formula Macnutt Excel Discussion (Misc queries) 3 October 19th 06 08:12 PM
I need today's date returned as date format in formula CMIConnie Excel Discussion (Misc queries) 2 February 23rd 06 05:38 PM
formula using date format Nigel Excel Discussion (Misc queries) 1 September 15th 05 08:42 AM
date format within a cell containing a formula Brushie76 Excel Discussion (Misc queries) 1 January 22nd 05 04:50 AM


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017