mcintoshmc
Active Member
- Joined
- Aug 10, 2007
- Messages
- 277
I would like to create a countdown formula that would calculate how many days until someone's start date. I know I can do A2-TODAY(), but that will result into a negative number if the date has passed, or if a person just doesn't have a date period. If there is no date, the result would be -43172.
I would like the formula to only reflect a positive number if the date is still in the future, and the word "Hired" if a negative number. I will make sure everybody has some type of start date.
I would like the formula to only reflect a positive number if the date is still in the future, and the word "Hired" if a negative number. I will make sure everybody has some type of start date.