Formulas looking at the year in a date field
I have a formula below that looks in cells E5 and H5 for the year in the date, if text is entered into one of the column's it come's back with an error. Is there something that can be done to stop this?
Let me know if i need to give you more information!=IF(E5="",YEAR(H5),YEAR(E5))
Regards,
Try IFError Formula
=IFError(IF(E5="",YEAR(H5),YEAR(E5)), "") This will give you blank if the result is an error.
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
Thanks for this, but i was hoping that the date of the other column that has a date in would still show?
You can use Data Validation in the date cells to enforce that entries are valid dates.if text is entered into one of the column's it come's back with an error. Is there something that can be done to stop this?
See this page for Data Validation Examples at Contextures
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks