Forum Discussion
Solved
Yearfrac stopping dates in future
Want to use yearfrac instead of datedif and it works but we want to have it give a value of 0 if one of the dates is in the future. I want to figure out how long someone has worked for us based on todays date and their start date.
Let's say you have dates in D2 and E2.
=IF(OR(D2:E2>TODAY()),0,YEARFRAC(D2,E2))
This can be filled down.
If you want to compare D2 to today's date:
=IF(D2>TODAY(),0,YEARFRAC(D2,TODAY()))
4 Replies
Let's say you have dates in D2 and E2.
=IF(OR(D2:E2>TODAY()),0,YEARFRAC(D2,E2))
This can be filled down.
If you want to compare D2 to today's date:
=IF(D2>TODAY(),0,YEARFRAC(D2,TODAY()))
HansVogelaar seems my colleague is happy with your solution. Thank you
Good to hear that. Thanks for the feedback.
- Awesome. I use today in a seperate tab so will give this a whirl tomorrow.
