We will learn how to format date in excel but before we begin let me tell you guys that we have daily updates on multiple technologies so if you're a tech geek in a continuous hunt for latest technological trends then consider getting subscribed to our youtube channel and don't forget to hit that bell icon to never miss an update from.
.png)
Simply learn now without further ado let's get started with our one point agenda that is how to format date in excel now we might want to get back to the practical mode so you can see on my screen we are on the excel spreadsheet and on my spreadsheet you can see dates in column a and different formats in column c d e and f respectively now by default the data type or the data present in the a column will be considered as general and there are a .
Few situations where even if you try to format the date in your format like you know the customized format you may not be able to do it because it's still under the general data type so for that for being on the safer side what we will do is select the data and navigate to the data toolbar and in that you have the text to columns option press that and remember to have the delimited icon you know you might be having the dash as your icon or slash as your icon .
For the delimited thing and select that and next next and here you can see right it's in general mode so you can press on date and dmi will be a date format that is date month and year now click on finish so it's been formatted now now let's copy the same data and paste it in all the four formats so that we'll see the different formats that we can change to or customize to right .
So there you go let's expand the columns a little bit now we have day month and year so now you might want to change a couple of things right for example you wanted to change okay let's see the menu so the way is to select the cells and right click and select the format cells option and in here you can see the date function and in here you can see different types of modifications that .
You can do to your data right so [Music] you might want to also change your dates based on the location so right now we are in india and imagine if you wanted to you know change something based on u.s or if you have if you're having your client in us and he wants the dates and us format you can also change that so here you can see english united states and press on that press ok and you can see it's been changed to us format where .
You have years in the first place months in the second place and dates in the last place right and now let us imagine that your client does not want the dates all he needs is just months right you can also do that get back to the format sales option go to custom and here instead of you know a month date and year you all you can do is just write down month and year and select okay so you'll .
Have only month and year not the dates now your client is being a little more you know he wants a little more detail and he wants you to add a lot of granularity to your data which includes day time etc everything right so you can also do that so the same way go to format sales custom and here i think it's in date itself so let's navigate a little .
Yeah here so you have the day date month and year press ok so there you go right so that's how you can do it and now let's try a little bit more if you have a few more options pending so go to format cells and custom and you also have timings so here you have date month year and the .
Timings press ok and they have all the timings as well so since these dates are you know i created them just a few moments ago to keep it simple so i did not have to add the diamonds here so if you are keen about adding the timings you can also do that for example if you wanted to add the timings of the employees logged in and logged out you can also do that using the same format so with that we have .
You guys must have heard of this word called the Paleo diet it's an American concept I don't believe in that entirely but what I do believe in is Indian value you also include dolls in this form of paleo dieting now what is paleo dieting essentially it's a low carb diet where you avoid all carb sources so you'll avoid right potatoes wheat any grain but you will include meat you will include veggies will include fruits and in the u.s.
Really include legumes like Dodge because they contain a little bit of carbohydrate that's why we're talking about Indian value level for the scale is Indian paleo where you'll eat fruits for breakfast and through the rest of the day you can have veggies and you can have anything except for the carbohydrates that we know of that's this list moving on and level 5 the ketogenic diet AHA job here bicep cachito bench .
We're talking about ito again because it is an effective weight loss diet contries or whatever people might argue a lot of people who think that sceeto isn't effective of keto isn't a good and healthy diet don't have a valid argument so I made an entire playlist on the ketogenic diet and fall you newbies a keto diet is once again a very low carb diet where your net carbs can't be higher than 20 grams a day net carbs all the carbs you get from even .
Your vegetables and those will be your only carb sources for the entire day and in strict keto that actually works your vegetables can only be green leafy vegetables you can't even eat carrots beetroot all that if you want more information on the keto diet makes you check out the ketogenic diet playlist I can't go over all the rules of keto in today's video but that's level 5 remember if you take up the keto diet it ..
Can be absolutely life-changing it will make you lose weight very rapidly this is the kind of transformation I had in a matter of two weeks through p2 now if you're someone who doesn't want to follow a low-carb diet your other option that level six is intermittent fasting once again and other protocols that I've spoken about on the channel myself if you want more information on it makes you check out the video I made on intermittent fasting and I've also put .
Up an if' diet plan for those if you want a details guideline but let's talk a little bit about level seven one I spoke about in the thumbnail of this video how do you lose 5 kgs in a week level seven is all about combining intermittent fasting with a ketogenic diet the whole point of keto or intermittent fasting and extreme protocol like that is to increase the speed of weight loss keto Hastings up your rate of weight loss and so does .
Intermittent fasting and it's completely safe to combine the two and get a super fast rate of weight loss you will end up losing 5 kgs in a week if you follow the rules of if' and the rules of keto to the tee remember it's a very difficult protocol to follow combining these already very difficult protocols but it's entirely your own and the final level I'm going to talk about is in healthy at all it's only meant for people we want to go for a photo shoot .
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
