***DATE HELP***
 

Two queries:

1. have a cell in format of dd/mm/yyyyy hh:ss. Need to dump into a new cell,
just the dd/mm/yyyy portion so that I can perform further calculations.
Everything I try displays just the dd/mm/yyyy data, but when the cell is
seleced, the hh:mm is still there.

2. Same situation when using the month function on a date. The function
output cell does indeed display the month, but the actual data in the cell is
still the date.

Have tried trimming, pasting values only and a whole bunch of other issues.
HELP!!!!

1. =INT(A1) and form at as date

2. and the question is? If you just want a month, try =TEXT(A1,"mmmm")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andy" wrote in message
...
Two queries:

1. have a cell in format of dd/mm/yyyyy hh:ss. Need to dump into a new
cell,
just the dd/mm/yyyy portion so that I can perform further calculations.
Everything I try displays just the dd/mm/yyyy data, but when the cell is
seleced, the hh:mm is still there.

2. Same situation when using the month function on a date. The function
output cell does indeed display the month, but the actual data in the cell
is
still the date.

Have tried trimming, pasting values only and a whole bunch of other
issues.
HELP!!!!