Solved

Date formula in two different cells

Posted on 2013-02-07
4
157 Views
Last Modified: 2013-02-07
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...
0
Comment
Question by:route217
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 38864413
Hi,

You could use =DATEVALUE(A2)

and format it

Regards
0
 

Author Comment

by:route217
ID: 38864418
Thanks for the feedback
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 38864447
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
 
LVL 50

Expert Comment

by:barry houdini
ID: 38864460
Hey, I was too slow!

Good answer Rgonzo1971!

regards, barry
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question