Combination of two cells data

  • Thread starter Thread starter gilbert
  • Start date Start date
G

gilbert

I remembered I seen somewhere before that we can combine two cells data
and text into another new cells using "&" (eg. 345&A1 where A1 is 1000
- the new cell will appear 3451000)

My question is how do we combine dates? For example, I need the year to
be seperated and date and month fixed throughout...so that each year I
will need to change the year to get a fresh sheet....eg..cell A1 is the
year, say 2004....I want cell D1 to Z1 running from 1/1, 2/1, 3/1, 4/1,
5/1.... plus the year. The end result would be something like that
1/1/2004, 2/1/2004, 3/1/2004 and so forth.

Pls help if you know how.....


Desperate for help here...
Gilbert
 
Hi Peo:

That only works for non-Americans <g>.

If the OP is following the US convention, he will need to use:

=DATE($A1,MONTH(D1)+1,1)

and copy across.

Regards,

Vasant.


Peo Sjoblom said:
If you have 2004 in A1, in D1 use

=DATE(A1,1,1)

in E1 use

=D1+1

copy across
Click to expand...
 
Hi Vasant,

Oops!

You are correct, I thought the OP wanted all the days of the month

--

Regards,

Peo Sjoblom

Vasant Nanavati said:
Hi Peo:

That only works for non-Americans <g>.

If the OP is following the US convention, he will need to use:

=DATE($A1,MONTH(D1)+1,1)

and copy across.

Regards,

Vasant.
Click to expand...
 
Back
Top