Thank you so much, SunnyKow!!! The only changes I needed to make to your formula was that the first > should be a < and to lock the $D$3 and no...
Are you getting it to work, because I am still getting "0" for the employees with 6 mos?
But they have reached their 6 mos anniv and therefore should have 1 day. That is what is making this so difficult. It is only difficult for the new ...
Hi, For instance, when I insert the suggested formula of: =IF(OR(E7>$D$3,I7>$D$3),0,K7) into Column L, the following employees [02JWC, 02RR, ...
Thanks SunnyKow, but I'm still not getting a 1 for the employees who have reached their 6 mos. That continues to be my issue. I did take the suggest...
I marked at the top of the spreadsheet, Column M is the column where the formula is needed, but that was before I deleted the names. It should be Col...