Forum Discussion
Solved
Using Datedif within Countif
I'm trying to create a formula that will run a datedif to give a day count and then to compare that day count to a listing of dates for the purposes of calculating an estimated accrual of PTO for wor...
Jonathan, was not able to load your second file as well.
As a comment, bit shorter variant of your formula is
=IF((Tenure!$H$8-$A2>=$U$2)*(Tenure!$H$8-$A2<=$V$2),$X$2*MAX($C2,80),…
Hi Jonathan,
It looks like uploaded file is corrupted
That's odd. Let me try and upload it again.