vacation accrual based on completion of 90 day probation

HI

Try this:

=IF(IF(40<(TODAY()-D3)*(40/(DATE(YEAR(D3)+1,MONTH(D3),DAY(D3))-D3)),40,(TODAY()-D3)*(40/(DATE(YEAR(D3)+1,MONTH(D3),DAY(D3))-D3)))<0,0,IF(40<(TODAY()-D3)*(40/(DATE(YEAR(D3)+1,MONTH(D3),DAY(D3))-D3)),40,(TODAY()-D3)*(40/(DATE(YEAR(D3)+1,MONTH(D3),DAY(D3))-D3))))