Hi Guys,
New to the board.
I'm struggling with a nested IF on a sheet that logs fork lift repairs.
Column K allows me to mark with a "Y" if the job is complete, and if so I want column N to calculate the number of days between the reported date and the repaired date, if it's not been repaired yet, then calculate the number of days between today and the date it was reported.
In column N I have =IF(K4="Y",(L4-A4),(A2-A4)) As you can see it works if the job is completed, but if there is no "Y" in K, then I want it to calculate days to today since we logged it. As you can see in N5, it doesnt like it.
New to the board.
I'm struggling with a nested IF on a sheet that logs fork lift repairs.
Column K allows me to mark with a "Y" if the job is complete, and if so I want column N to calculate the number of days between the reported date and the repaired date, if it's not been repaired yet, then calculate the number of days between today and the date it was reported.
In column N I have =IF(K4="Y",(L4-A4),(A2-A4)) As you can see it works if the job is completed, but if there is no "Y" in K, then I want it to calculate days to today since we logged it. As you can see in N5, it doesnt like it.