Could anyone correct the formula below somewhere between TEXT and INDIRECT formulas, thanks for your assistance.
worksheet 1 called: Journal#1
cell T4: 1 Jul 2010
worksheet 2, cell L1 = 1
cell G4...
="OPENING BALANCE IN BANK AT "&UPPER(TEXT(INDIRECT("'Journal#"&$L$1&"'!T"&4,"dd mmmm yyyy")))
Bookmarks