It’s my pleasure Rick. Nice to see you here and thanks for commenting!

Mohammed Hussain,
Thanks for the comments 🙂

Hi Mark,
Use the following formula instead of the formula you’re using.
=DATEDIF($B$1,$B$2,”Y”)& ” years, “&DATEDIF($B$1,$B$2,”YM”)& ” months, “&ROUNDDOWN(DATEDIF($B$1,$B$2,”MD”)/7,0)&” Weeks, and “&DATEDIF($B$1,$B$2,”MD”)-ROUNDDOWN(DATEDIF($B$1,$B$2,”MD”)/7,0)*7&” Days.”
Regards
Kawser

Hi Jon,
I am going to add it.
Thanks for your tips.
Best regards

I am taking a note of your suggestion. Thanks.

Hi Mike,
I am taking note of your problem, we shall make templates on the basis of your needs.
Thanks.

Thanks, Pedja for your feedback.
Best regards.

I am keeping a note of your problem. Thanks.

Hi,
If we make a template for that problem, I will email you. Thanks.

Wayne,
Thanks for your feedback.

Kanhaiyalal, thanks for your wonderful feedback.
Best regards

You’re most welcome. Glad to know that it helped you.

You’re most welcome, Obuo!

Thanks for your feedback, LuluBelle! Glad to know that it helped.

Idowu,
Thanks for your feedback. Glad to know that it helped you.
Best regards

Hello Johmono,
You’re most welcome.
Thanks for your feedback.
Best regards

Please check your email inbox.

You’re most welcome. Glad to know that it helped you. Thanks for the feedback.

Thanks for the feedback. Hope you will find this technique useful for your next some jobs.
Best regards
Kawser Ahmed

Please check your email.
Thanks.

Please checkout your email. Thanks.

Thanks for your feedback.

It is actually important 🙂 Thanks for your feedback.

You will also find the file in our article. The file is at the upper part of the article. You will find the file under this title: “Calculate Hours Worked and Overtime Excel Template”.
Best regards
Kawser Ahmed

Most welcome, Nilesh 🙂

Maybe it is due to the payment time. Do you pay at the beginning of the month or at the end of the month?

Thanks for your feedback, Mdu!

Check your email please.

Thanks for your good words, Dayo!
Best regards
Kawser Ahmed

Thanks for the suggestion 🙂 I will keep it on my list.

When we have more than one files for an article, we make a compressed file.
Hope you understand. Other articles that have just the Excel file to share, the download options are in Excel File.
Best regards
Kawser Ahmed

It is sad to hear that you did not get the PDF. Just check your email.
Thanks and regards
Kawser Ahmed

Glad to know that it helped you.
Thanks and regards
Kawser Ahmed

Hi Gilbert,
I am really sorry for not having PDF formats of the Articles.
But you can make your own PDFs. Only thing is: you can use it personally. Not for commercial use, of course.
Hope you understand.
Thanks and regards
Kawser Ahmed

You’re welcome, Frank! Feeling good to hear that this article helped you.
Best regards

Nice to hear that it helped you. Thanks and regards.

You’re welcome, Andrew 🙂

Thanks, Ferreira!

Thanks, FERREIRA for your feedback!

Please check out your email.
Thanks.

You’re most welcome 🙂 I am glad to know that our tutorials add some value to your life.

Thanks for your feedback 🙂

I will check this issue and let you know. Glad to know that we can add some value via our emails.
Best regards
Kawser

Thanks for your input, Greg.
Best regards

Glad to know that it helped you to learn something new.

Hi,
You can try to use the concepts in real-world problems.
Thanks.

Thanks for your feedback, JG. I will think about a method as per your necessity.
Best regards
Kawser

Thanks a lot for the feedback. I shall input this method when I will update this article later.

Thanks for your valuable comment. Unfortunately, right now I don’t have any dashboard like that. Maybe later.
Thanks and regards

Thank you so much for your feedback.
Best regards

Thank you for your valuable feedback. It’s something 🙂
Best regards

Thanks for your valuable feedback.

Thanks for your feedback. Glad to know that it helps you.

Thanks, Mark.

Thank you for your feedback, Anirudh!
Best regards

Ram,
I have a list of Excel books that is good for learning Excel from the beginning. Please visit this page: https://www.exceldemy.com/best-excel-training-books/
The best is obviously the Excel Bible Series. You will get the link on the page. If you talk about Video Channel, it is tough to find one as most of them don’t start from the beginning. But if you search for a topic, there are several. One of the best is ExcelIsFun YouTube channel. I hope it helps.
Best regards
Kawser

Hi Mike,
Check out your email.
Thanks.

Thanks, Emil!

You are welcome.

Thanks for your feedback, Uche Uche.
Feeling happy to know that you found the articles helpful.
Best regards
Kawser Ahmed

Thanks for your feedback, George!

You can collect it from our resource page. The resource page is shared with every subscriber, every day.
Best regards
Kawser Ahmed

You are welcome, Chandrasekhar! Glad to hear that our tips help you.
Best regards

Hi Stanley,
Thanks for the comments. Glad to hear that it is helpful. Yes. You can share it with an online class with an attribution to our blog.
Best regards

Hi Anatoly,
We have written a detailed guide on solving equations using Excel. You will get the guide here: https://www.exceldemy.com/solving-equations-in-excel/
If you have some specific equation, let us know via email.
Thanks and regards.

Thanks for asking. It was creating more indexed pages in Google that was bad for us. What you can do is: just you can copy the whole article and paste into a word document and then convert it into a PDF file. There is little chance of getting back of that button.
Best regards

Hi Ajeet,
Then you can download it from the Excel Resources Page that you get in every email I send.
Thanks.

Thanks. Glad to know that you found it useful.

Thanks for your feedback, Ven!

Mike,
Thanks for your feedback 🙂
Kind regards

Please check your email.

Thanks for your feedback. Best wishes with your new journey 🙂 Excel, Word, and PPT are three most powerful office tools. I’m sure, you will enjoy your journey 🙂

Hi Bob,
Did you download the Excel file before you follow me? Please do so. I’ve explained the whole process with two real time examples. If you can create these two examples in the Excel file, I hope you will be able to understand the whole system.
Best regards
Kawser

Thanks, Subbu!

Thanks for your feedback 🙂

Syed,
Sometimes when the formula is posted in WordPress platform, it might be changed. Please, download the working file and check the formula there.

Roger, thanks a lot. I did not notify the issue. It’s a crucial problem. I am working on it.

Roger, this option (make PDF of the blog posts) is on my plan. Will execute in shortest possible time.
Best regards and thanks for the comments.

Please check your email, Kaz!
Thanks.

It’s a good idea, Rahul. I will think about it soon.
Best regards
Kawser

Please check your email, Sohail!

Please check the email 🙂

It’s sent, check your email.

Raja, any working file on that?

Many thanks, Scott!

Check your email please, Smith!

The working files are uploaded. Thanks!

If cell A1 holds your string “BCD” and you want to show “AAAAAAABCD” in cell B1, input this formula in cell B1: =REPT(“A”, 10-LEN(A1))&A1.
To solve this problem, you don’t have to use any looping. Or, do you have some other requirement for this problem? Let me know.
Best regards.

Thanks Fina for sharing.
Regards

Please check your email.

Borb,
I tried to reach you to your email address but it is showing the mail cannot be reached.
How can I help you?
Regards
Kawser

Waleed,
Can you upload the working files of your problems? At least a sample file? If possible send an email to this address kawser@exceldemy.com

Baber,
I have sent you an email with instructions. Please check. I hope the email solves the problem.
Regards

Mike, you did a phenomenal job! Thinking in that way, awesome and the alternative!; Hats Off!

Yes, Menon! It’s a nice solution and more generic!

Cool 😀

Please check your mail, Lilly.

Please check the mailbox. I have sent you an email with the direct download link of the resources.

Hi Gina,
Thanks for notifying me. I manually checked the whole process and found some problems. It is fixed now. Please check your inbox. I have sent you the link of the resource page.
Best regards
Kawser

Hi Roger,
Thanks for your feedback. Nice to meet an Excel Pivot Table ninja 🙂 If you like you can share your ninja skills with my audience.
Regards

Thanks Jan for your feedback.

Vikas,
Glad to know you liked it. Thanks for your feedback.
Regards

OZ thanks for your feedback. I am going to write these types of posts like a series. Your comments made me more inspired 🙂

It’s my pleasure Bob. Thanks for sharing.

Shivaji,
Right now I have no book on Microsoft Access. But just subscribe my Email list using the below link, you will get two books on Excel: 1200+ Macro Examples E-Book, 220+ Excel Keyboard Shortcuts E-Book and other Excel resources.
http://www.eepurl.com/bqFItv

Glad to hear that my website is helping you in a way.
It’s my pleasure Mohammed Hussain. Keep in touch 🙂

Rajesh,
If you’ve given names to the changing cells and result cells, the table uses these names; otherwise, it lists the cell references. Just use some names for the cell references B13, C13, D13 and B15 in the Sheet1 Worksheet in the provided Workbook. Then create the Summary Report again. You will get the result cells using some names.