How to Get Day Name from a Date in Excel
Let’s say you have a date from that date you want to get the day name… i.e. Sat, Sunday. This can be done with a formula. In fact, there is more than
Let’s say you have a date from that date you want to get the day name… i.e. Sat, Sunday. This can be done with a formula. In fact, there is more than
Let say you have a line-up of 20 products in your company and you have data for monthly sales of all the 20 products. From that data, you want to calculate
Sometimes you need to calculate the total number of days in a month… …to use in the further calculation. It happens specifically when you work on templates and dashboards.Sometimes you need to
From the starting days of my job, I have learned one thing hard way: Before sending a report (In Excel) to someone we must convert a formula to value. It simply means
It happens sometimes you send Excel files to others and they made some changes into formulas. Or, sometimes you simply don’t want to show a formula to others.Hiding a formula
You need to learn how to insert and use a degree symbol in a cell.That’s right.Let me tell you why I’m saying this.Yesterday I was working on some temperature data.For