TECH-004 Calculate total days between two dates in Excel
YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
Learn how to easily calculate the number of days between two dates in Excel.
In this video you will learn how to use the TODAY formula, the ROUND formula, and the ROUNDOWN formula.
I hope these formulas are something you can use in your daily routine so you get better results with less effort.
If you have a challenge with Excel that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.
Thank you for watching.
Check out some of our previous videos in the links below:
* TECH-003 - Display images in comments
• TECH-003 - Insert imag...
* TECH-002 - Find intersecting values in a table in Excel
• TECH-002 - Find a valu...
* TECH-001 - Compare data in charts selecting values from dropdown menus
• TECH-001 - Compare dat...
Пікірлер: 8
Hello, is it possible to plot 2 schedules in 1 gantt chart ? 1st is the master plan ? and 2nd is the sub plan.
You are doing a great work. i will leave you a challenge in excel. very soon :)
@TheExcelChallenge
7 жыл бұрын
By all means, please send it and I'll be glad to post a solution for you and for other viewers to watch and learn some Excel tips and tricks.
Can you do Gantt charts in weeks?
I was looking for a formula that would provide billable days to include the first day?
How could I get one day to equate to working hours or even working minutes? So instead it calculates minutes in between according to the day or even time range
Creating a work schedule M-F exclude weekends 2 days how do I create a formula to remove weekends
In this video you just show 37 years, 37 days. But 13551in this number, How i show 37 years 1 months 7 days. Please give me appropriate reply