Hello I am new here, I have created a sheet that looks up the oldest date in a column from another page. However if there are no dates in that column it displays "01/00/00"
This is the formula I am using: =MIN(SheetName!N:N)
What I would like is for it to display either "N/A" or just a null cell if there is no date in the page column I am referencing.
Tried some IFELSE and IFERROR combinations but they only seem to work with VLOOKUPs
Any suggestions? Thanks!
Bookmarks