Thank you very much, for your time and your solutions!

You are a great teacher! That was an awesome video...thank you so much!

Great man,Thanks! You save me a bunch of time.

Thank you man. Very easy and clear video.

Very helpful tutorial. I will be able to apply this to my excel file. Keep doing tutorials brother and God bless.

Hi... do you think you can create a project manager program and conect to calendar to remind what is left to do. that will be awesome.

This was really helpful. Thanks so much.

Wonderful.. Thank you.

Thank u for the great job 👍

This was exactly what I was looking for. What I wanted to do worked with WPS Office too. I did not do the color coding.

You are doing a great job! well done! (Y)

@TheExcelChallenge

6 жыл бұрын

Hello Munawar. Thanks for watching and for sending these comments. It's nice to hear you like the videos. Stay tuned for more videos coming in the near future.

Gracias! 😀

Thank you very much

thank you!

Thanks mate

Hello, I love your videos. how can I best set up an excel sheet for an unpredictable daily schedule?

Thanks Sir 👍

great , many thanx

@TheExcelChallenge

6 жыл бұрын

You are welcome Fahad. Good to hear you liked it. T-E-CH

Question this was a GREAT Resource! but could you show where lets say the today date is different from all the other todays date. For example if I needed to track different customer remaining days from different days the were enter into the system or when services started how do we do?

great sir

Hey! Greeeaat Video! Can I do that with hours?

Is there a way to do with time, as in hours and minutes? For example, If I place a bid on an item and the item's bid expires at 4:30pm on Oct 10th (and today is the 5th), is there a way to make a countdown timer for this?

Could you create a tracker that automatically updates when tracking due outs by the categories: OVERDUE, less than 29 days out, 30+ days out, 60+ days out and 90-120 days out? The columns would have other topics like dates, names and what is due

Can you prepare a Preventive Maintenance Schedule template for daily,weekly and monthly works on a operational for engineers etc

sir Super

Would you please provide an example of how to write this formula: If (today's date) is I would also like to know how to lock H11 following 2/31/2020

hi, how to stop countdown with the end date?

Is there a date countdown formula that says at ZERO when the date is passed? All the date formulas I have tried keeps counting with negative numbers once the deadline date is passed. HELP!

Can you upload a simple database entry with search option vba.......please...

Sir we need more videos plz update

Hi my name is werner Bonete my challenge is what would you do to make value in separate columns for example : 123.45 the result is like this column I 1 I 2 I 3 I 4 I 5 I thank you

@TheExcelChallenge

4 жыл бұрын

Hello Werner, Use the LEFT, MID, and RIGHT formulas. LEFT will give you the 1. MID will give you the 2, 3, and 4. RIGHT will give you the 5. Try that. Thanks T-E-CH

@wernerbonete6181

4 жыл бұрын

OK sir thank you so much for your reply

@TheExcelChallenge

4 жыл бұрын

My pleasure. Good luck!

Challenge !!!!!!!!! How is it possible to color only the date in the specific cell at a specific place, but the date is not hard coded. it is showing with formatting... so, for example how can you highlight just the dates in this formula but not other text. ="Time Sheet from "&TEXT(A5,"dd/mm/yyy")&" to "&TEXT(A6,"dd/mm/yyy") of course A5 and A6 have two different dates.

plese help, it gives me a date instead of a number

@TheExcelChallenge

3 жыл бұрын

Hello Hunter. Right click on the cell (or cells) with the problem and go to Format Cells. Once there, select a different format than date, like “regular number” and that should resolve your problem. Thanks for watching T-E-CH

@hunterkendrick6294

3 жыл бұрын

The Excel Challenge worked great!!! Thank you

@TheExcelChallenge

3 жыл бұрын

Glad to hear Hunter. Take care and stay safe. T-E-CH