Forum Discussion
bterning
Oct 11, 2020Copper Contributor
countdown from a date
I am not familiar with Excel jargon, so I'm having a hard time knowing how to ask what I need my spreadsheet today. This is what I need it to do: When someone admits to the facility I work at, some ...
bterning
Oct 11, 2020Copper Contributor
Thank you so much! It worked! I want to learn more of this to make my work more efficient. This is a game changer!
JMB17
Oct 11, 2020Bronze Contributor
Since you are fairly new, I should point out that this part:
(TODAY()=A2)
Works the same as this:
IF(TODAY()=A2,1,0)
For Excel TRUE=1 and FALSE=0, so I'm using a small shortcut.
(TODAY()=A2)
Works the same as this:
IF(TODAY()=A2,1,0)
For Excel TRUE=1 and FALSE=0, so I'm using a small shortcut.