[틱톡 따라하기] How do I calculate days remaining from today in Excel - Excel Tips And Tricks

https://www.tiktok.com/@xybernetics247/video/7247477450173631749?_r=1&_t=ZS-8zdI08NAz84

TikTok · Xybernetics247 님

 

Project Deadline Tracker

 

🔗 지금 바로 사용해보세요!

📥 데드라인 추적 스프레드시트 바로가기

클릭 한 번으로 바로 접속해서 복사하여 사용하실 수 있습니다

 

1) Select cell C2

2) = TODAY() - B2

3) Apply too rows

4) Ctrl + 1
5) Number tab → Custom

6) [빨강]# "Days Overdue";[파랑]# "Days Remaining";[녹색] "Today"
7) OK