Date Functions and Formulas in Excel

Sir it’s not working in my excel, i use ms 365. Don’t know why, i followed your steps already. Hope to hear from you soon!

How to you add a year like it I want to enter day then add a year to the date column

This is awesome

❤

How do I separate dates from beginning dates to calculate 30, 60, 90, 120 days of more?

Ok so thank you I’ve been trying to work a formula for this. I have a list of customers who get 2 points for every month after their start date. I’m going to try it at work tomorrow and see if it works out. 🙏 if not, is it possible to ask for assistance?

I am using a Pivot table to view how many clients enter my shop each day. I am able to filter the dates so I can see each day's total if its within the past week, but I cannot figure out how to show the data within the past two weeks. I am almost positive I can use a custom formula however I can't find any information anywhere. Is it possible you know how? thank you

Thank you for your excellent videos. They are the best on the internet!! PLEASE would you do a short BASIC video on DATES, the basics. How to enter dates, ensure they are numeric and not text ie on the right side of the cell, how to correct them if I entered the dates wrong and the how to SORT BY DATE. Due to my house burning and I was in a Motel for eleven months I have a huge pile of receipts to submit to the Insurance. The pile of receipts are not in any date order. I would like to just start at the top of my pile and enter each receipt. Then I would like to SORT them into date order. The first date was April 4, 2021 going through to February 20, 2022. PLEASE PLEASE PLEASE. I am so overwhelmed.

Very helpful! Thank you!

I’ll have a spreadsheet with a start time and an end time and I would like a column that tells the difference or elapsed time between the two…do you know of a formula that will do this?

Cool tutorial, Thank you 👍🏾

Thank you! Sir.. You are so generous that we can practice the excel exercise for free and you elaborate on the formula very clear!!

Muchas Gracias !

Thank you for this tıtorial.
So, how can we find out the month number from month name. For example, if we have mounth name like october or june or may, how can we obtain month number from those names?

I learned a lot from your videos, thanks for sharing.

Impressive

What if I want to know how many days from one date to another, including the day of and excluding leap years

Muchas Gracias !

Very amazing, thanks alot Boss

Or you can enter the date in a blank cell, go to format,/custom and enter four d's (or m's) to achieve the same result.

Thank you for the awesome explanation.
I have a dataset, where the date and the time are updated through queries from a website in the same cell.
Is there a way to seperate the date and time on the same?

Simply brilliant sir. Thanks

Thanks 🌹 😍

Love the way you teach ! Thanks 😊