Ask Your Question

How do I use the value a cell from a sheet in a formula on another sheet? [closed]

asked 2017-01-23 19:22:52 +0100

Mikie gravatar image

updated 2020-08-03 12:51:55 +0100

Alex Kemp gravatar image

I have a value on the second sheet in cell C2 --> 02/01/2016 I have cells on other sheets with formula such as: --> =TEXT(Sheet2.C2,"mmm - YYYY")

Unfortunately the above equation (on the third sheet) yields the answer --> Dec - 1899

Everything I find concerns filling and propagating, but not using in an equation.

Would appreciate some help.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-03 12:52:10.102445

1 Answer

Sort by » oldest newest most voted

answered 2017-01-23 19:48:59 +0100

Mikie gravatar image

Okay, I have it now.

I was using the word "Sheet2" as the reference, I used the name of the sheet and it worked.


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-01-23 19:22:52 +0100

Seen: 87 times

Last updated: Jan 23 '17