date format
 

hey all,

I have worked out the first and last day of the month by using these
formulas

cell A1 is =NOW()
cell B1 is =DATE(YEAR(A1), MONTH(A1),1)
cell c1 is =DATE(YEAR(A1),MONTH(A1)+1,0)

and now I want the results of B1 and C1 in one cell which I thought I
could do with, cell D1 is =b1&" - "&c1

but everytime I try this I loose the date format in D1 and I can't get
it back.

Anyone got any ideas.

Cheers


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=506733

date format
 

=TEXT(B1,"dd/mm/yyyy")&" - "&TEXT(C1,"dd/mm/yyyy")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Hru48" wrote in
message ...

hey all,

I have worked out the first and last day of the month by using these
formulas

cell A1 is =NOW()
cell B1 is =DATE(YEAR(A1), MONTH(A1),1)
cell c1 is =DATE(YEAR(A1),MONTH(A1)+1,0)

and now I want the results of B1 and C1 in one cell which I thought I
could do with, cell D1 is =b1&" - "&c1

but everytime I try this I loose the date format in D1 and I can't get
it back.

Anyone got any ideas.

Cheers


--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=506733

date format
 

Modify the data values to strings using this variant of your existing formula:

=Text(b1,"m/d/yyyy")&" - "&Text(c1,"m/d/yyyy")

If you want different date formats, you can use "dddd, mmmm d, yyyy",
"yy-mmm-dd", just to name a few...
--
Kevin Backmann


"Hru48" wrote:


hey all,

I have worked out the first and last day of the month by using these
formulas

cell A1 is =NOW()
cell B1 is =DATE(YEAR(A1), MONTH(A1),1)
cell c1 is =DATE(YEAR(A1),MONTH(A1)+1,0)

and now I want the results of B1 and C1 in one cell which I thought I
could do with, cell D1 is =b1&" - "&c1

but everytime I try this I loose the date format in D1 and I can't get
it back.

Anyone got any ideas.

Cheers


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=506733

date format
 

try using TEXT
=text(b1,"mm/dd/yy")

--
Don Guillett
SalesAid Software

"Hru48" wrote in
message ...

hey all,

I have worked out the first and last day of the month by using these
formulas

cell A1 is =NOW()
cell B1 is =DATE(YEAR(A1), MONTH(A1),1)
cell c1 is =DATE(YEAR(A1),MONTH(A1)+1,0)

and now I want the results of B1 and C1 in one cell which I thought I
could do with, cell D1 is =b1&" - "&c1

but everytime I try this I loose the date format in D1 and I can't get
it back.

Anyone got any ideas.

Cheers


--
Hru48
------------------------------------------------------------------------
Hru48's Profile:
http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=506733

date format
 

Many thanks all!


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=506733