Date formula in two different cells

Hi Experts

I have the following date formula in cell a2 =Text(Now(),"mmm yy")
Works fine

In cell A1 I would like to show 01/02/13 - currently I have =a2 as the formula in cell A1...

So the end result has to refer cell A2 but be shown as 01/02/13 in A1...

I believe need to apply a custom formula selecting cell and going to front cells> custom etc...
route217Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

You could use =DATEVALUE(A2)

and format it

Regards
0
 
route217Author Commented:
Thanks for the feedback
0
 
barry houdiniCommented:
Do you mean A1 should show the 1st of the current month? You can do that by using

=TODAY()-DAY(TODAY())+1

or if you want to refer to A2 try

=(1&A2)+0

format as a date

regards, barry
0
 
barry houdiniCommented:
Hey, I was too slow!

Good answer Rgonzo1971!

regards, barry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.