Callum Mc Adam
New Member
HI Excel Ninja's
Hope you can help me, i pull reports from our system and each line date has the full time included. I usually used the =YEAR(B1) Formula to only include the year and that has worked fine. i recently moved to the latest version of office (2016 - on Office 365 E3 Plan) and now the =YEAR() Formula no longer works.
Attached is an example of the Date Format and Year Formula.
I have tried Changing the Column Format but that doesn't seem to work.
I would be eternally grateful for any assistance.
thank you
Callum Mc Adam
South Africa
Hope you can help me, i pull reports from our system and each line date has the full time included. I usually used the =YEAR(B1) Formula to only include the year and that has worked fine. i recently moved to the latest version of office (2016 - on Office 365 E3 Plan) and now the =YEAR() Formula no longer works.
Attached is an example of the Date Format and Year Formula.
I have tried Changing the Column Format but that doesn't seem to work.
I would be eternally grateful for any assistance.
thank you
Callum Mc Adam
South Africa