Notifications
Clear all
Excel Expert
2
Posts
2
Users
0
Reactions
170
Views
Topic starter
Whenever I use a lookup formula on a field containing dates, if the field was blank, the lookup returns 1/01/1900. For example, when I am using employee data, I often use hire and termination dates. The hire date is always populated for active employees. However, the termination date field is blank for active employees. Is there any way to suppress the 1/01/1900 and see a blank when I do a lookup for termination date?
Posted : 11/06/2024 11:01 am
You can write a formula like:
=IF(ISBLANK(termination_date),"",calculation)
Come back here if you get stuck.
Posted : 11/06/2024 12:46 pm
