Extract a value if today is between start and end date
I've been trying to wrap my head around this and I have trouble trying to self serve to find an answer (or it's just user error on my end haha)
I have a schedule with 3 main columns - the name, the start date and the end date. What I was hoping to do was extract who is currently scheduled if today was equal greater than the start date and if today was less than the end date. It seemed easy enough in my head but I may be doing something wrong.
Anyone have any suggestions?
Help Article Resources
Check out the Formula Handbook template!