Look Up

  • Thread starter Thread starter Pass-the-Reality
  • Start date Start date
P

Pass-the-Reality

On the Summary tab I want to type 2010 YTD = [BLAH] into cell B2. I want the
Blah to represent the data currently in cell A2 on the Data Tab. How would I
write this formula?
 
Hi,

Like this

="2010 YTD " & TEXT(Data!A2,"dd/mm/yyyy")

Change the date format to the one you want
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top