IF Statement & lookup to other columns - Job Application Spreadsheet

Good afternoon all,

I am putting together a spreadsheet for job applications, and I am bit stuck on how to do this second stage...

Currently:
1. Column S 'Follow up' looks at Column J 'Date Applied' to check how long it has been since I applied and whether a follow up is required.
Formula:
=IF((TODAY()-J6)>25,"2nd Follow-up",IF((TODAY()-J6)>18,"1st Follow-up",IF((TODAY()-J6)<10,"No Follow-up","")))


2. I would like Column S to also look at Column Q 'Follow-up' date as well, to then give an output value such as 'another follow-up required' or similar.. (Possibly another statement such as IF statement? Unsure)







Any tips?

Thank you.
Capture.JPG

=IF((TODAY()-J6)>25,"2nd Follow-up",IF((TODAY()-J6)>18,"1st Follow-up",IF((TODAY()-J6)<10,"No Follow-up","")))
what happens between 18 and 10 - just a blank
I assume that if its > 25 then a first follow-up should have happened

you could use an AND to test if a date exists in Q and if it does use that date
But a spreadsheet rather than a picture would help , with some example out puts in S and why

you didn't cover day 14 changed
=IF((TODAY()-H3)>25,"2nd Follow-up",IF((TODAY()-H3)>14,"1st Follow-up",IF((TODAY()-H3)<15,"No Follow-up","")))

S is nolonger a follow-up date

In row 3 - you have 2nd follow-up BUT no date in L - so you have not completed the 1st follow-up
Did you want to test L now ?

The status column A could clear the follow-up - IE if not selected , then no point in follow-up
I assume the follow-up would change based on the status
maybe getting more complicated

good luck by the way, my son was made redundant in July, so I know how hard this is at the moment

Anyway

Not selected would also apply to the follow-ups
Did you want to flag follow-up for interviews?

Ok,
glad its all worked out for you
Thankless task, and quite stressful , especially when NO feedback is provided.
All the best and wish you luck on your job search.