I am trying to keep track of different screens that are active during a set amount of time. There is a “Start Date” column and an “End Date” column. I need a column that will automatically put a yes or a check when today’s date falls between the Start and End. I’ve tried this but it’s not working:
What’s your desired end result? In your initial post you said you wanted a check mark, and the check emoji does that, so I think we’re confused about what you hope to accomplish by changing the formatting. What format would you like it to be? Only numbers and dates have formatting options. The check emoji is considered to be text, and text output from a formula can’t be formatted.
@Justin_Barrett I’m not sure what you mean? Sorry, I’m new to formulas. I’m not trying to change any format, that I am aware of. Why can’t the output be text? All I want it to do is put a little check mark if today’s date falls between the Start and End. The formula does work if I put a number instead of the check mark, but I would like the check mark for organizational purposes. Does that make sense?