Craig Peter DG
New Member
- Joined
- Sep 10, 2016
- Messages
- 33
- Office Version
- 2013
Hi, have come to the board because I cant find a solution anywhere else.
Having probs with a YEAR function, keeps returning #VALUE error even though the cell is referencing a Date formatted cell. The date formatted cell is in United States date format, thus 12/15/2020 (15 December 2020). The date cell is itself a formula extracted from another sheet within the workbook and i have triple checked that the date returned here is correctly formatted as a date. However, i now want to extract the YEAR from that date in the adjacent column but i keep getting a VALUE error. Solutions please? Here is a snapshot of my excel table.
Having probs with a YEAR function, keeps returning #VALUE error even though the cell is referencing a Date formatted cell. The date formatted cell is in United States date format, thus 12/15/2020 (15 December 2020). The date cell is itself a formula extracted from another sheet within the workbook and i have triple checked that the date returned here is correctly formatted as a date. However, i now want to extract the YEAR from that date in the adjacent column but i keep getting a VALUE error. Solutions please? Here is a snapshot of my excel table.
VAERS ID# | ID Source this Wbook | Date Reported to VAERS | YEAR |
902440 | 2020CV19EventsPHARMA | 12/15/2020 | #VALUE! |