Hi All,
I am trying to write an formula which should plot "year" info, where it was loaded in a list. This is about dates we manually loaded in a particular year. Now i want to extract the year info on the cell where this was loaded and not the year that the date mentions. For example we loaded 31-Dec-2018 in Year "2019" in the Year* list, where this data was loaded. When i type below formula, "Year[Select: Time.'Current Period']", system gives current year, i.e. 2018. When i write YEAR(START()), system again plots "2018". When i write FINDITEM('Year*', TEXT(Year)), system again gives 2018.
My question is how to get 2019 as year on a cell where the data was loaded?
Any help from you experts holds high value to me. Thanks!