Hi,
This question relates to Excel 2010 and is weird ... so please excuse the dippy question.
I'm using the DATE= function to assemble three values but getting the wrong answer.
F22 = 6
G22 = 4
H22 = 2012
In cell F23, =DATE(F22,522,H22) gives the result 03/12/1954 not 06/04/2012
In Excel's regional settings, the location is English (UK) and the PC runs Windows 7, which shows the location as United Kingdom with a format of English (United Kingdom).
The context is that each year, I want to change the financial year in just one central cell, B1 (eg = 2013) and all cells update automatically.
Thanks for any help
Bookmarks