Custom Format Cell with Reference to another sheet
 

Hi
I know this somehow can be done, but having trouble understanding it.

What I have is 2 sheets eg MISC ATB and MONTH ATB

In a cell on the MONTH ATB I would like to have in a cell "GENERAL" &
refencing a date on the MISC ATB sheet say A2 and this to be formatted as
MMM-YYYY
Thanking you and hoping you can help

Custom Format Cell with Reference to another sheet
 

Try the below formula

="GENERAL " & TEXT('MISC ATB'!A2,"mmm-yyyy")

--
Jacob


"enna49" wrote:

Hi
I know this somehow can be done, but having trouble understanding it.

What I have is 2 sheets eg MISC ATB and MONTH ATB

In a cell on the MONTH ATB I would like to have in a cell "GENERAL" &
refencing a date on the MISC ATB sheet say A2 and this to be formatted as
MMM-YYYY
Thanking you and hoping you can help

Custom Format Cell with Reference to another sheet
 

Thanking you very much, the problem was that the original data was not
formatted as a date. Having typed you formula which was similar to what I
was originally trying to do, made me look further.

Thanks again


"Jacob Skaria" wrote:

Try the below formula

="GENERAL " & TEXT('MISC ATB'!A2,"mmm-yyyy")

--
Jacob


"enna49" wrote:

Hi
I know this somehow can be done, but having trouble understanding it.

What I have is 2 sheets eg MISC ATB and MONTH ATB

In a cell on the MONTH ATB I would like to have in a cell "GENERAL" &
refencing a date on the MISC ATB sheet say A2 and this to be formatted as
MMM-YYYY
Thanking you and hoping you can help