Excel returns a serial number instead of the year, resulting in logic error. I need to keep the logical about comparing YEAR as this formula will be part of a larger lookup formula.
In order to return TRUE, "1997" = stores_beg!$G$1.
Screen Shot 2019-09-07 at 9.54.27 AM.png
Although stores_beg!$G$1 does refers to 1997...
Screen Shot 2019-09-07 at 9.55.19 AM.png
... however, it evaluates to a serial number 35795.
Screen Shot 2019-09-07 at 9.53.58 AM.png
The following have not worked:
1. year()
2. custom number format
3. date number format
This was originally the header for a table. Does it matter if the date is the header of a table, or whether it's just a range?
A sample file is a attached.
Thank you!
Bookmarks