Can two date columns feed the same calculated column depending on which one is answered?
I have a date column that is prepopulated based on a connection to another sheet of current employees. From this, I have calculated the number of days since an event. If these employees are no longer in my connected sheet, this date becomes a #No Match. I've created a second column of manual entry dates for these terminated employees. My goal is to get this second column to feed the same "# of days since the event". I've tried multiple 'If' statements but have not had any luck. Is there any way to feed this singular column depending on which of the two dates are populating?
Answers
-
A Screenshot of your column names?
An if statement would be structured like this
=IF(ISDATE(Date1),Use Date1,Use Date2)
-
Here are the column names I'm working with.
-
Try something like this
=IF(ISDATE([Clinician 1 Hire Date]@row), NETDAYS([Clinician 1 Hire Date]@row, TODAY()), NETDAYS([Clinician 1 Hire Date (Terminated)]@row, TODAY()))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!