I'm trying to make a recruitment sheet for an online community I help run. What I'm currently attempting to do is that when we record a person has joined the Discord to column B, it'll automatically propagate the date joined in the corresponding space in column D.
I've never messed with date or timestamp functions in excel, so I'm not really sure where to start with this. I tried doing a bit of googling, but all that came up was 'how to create an auto-updating date.'
Here's my Test Sheet.