Microsoft Excel Number of Days in a Month
If, for example, you want Microsoft Excel to calculate the number of days in a date, then you can use the following formula:
=DAY(DATE(YEAR(B2),MONTH(B2)+1,1)-1)
Where B2 is the cell with the date you want to calculate total days in the month for.
Here is a snap shot of what I mean:
Categories: Microsoft Excel, Software Tags: calculate, microsoft, Microsoft Excel, number
Microsoft Excel: Removing Hyperlinks From Cells
Removing hyperlinks from cells can be tricky in that you can trigger them when you don’t intend to. So what is the best way to remove them?
- Select a cell not to far from the cell with a hyperlink
- Use your arrow keys to navigate to it
- press CTRL+X, a shortcut to cut the contents of the active cell
- from the Edit menu to find Paste Special
- a dialog box should appear, here select Unformatted Text
Job done!
Categories: Computers, Microsoft Excel, Software Tags: arrow keys, cells, dialog box, hyperlinks, job, microsoft, Microsoft Excel
Microsoft Excel Quick Instant Graph Tip
There is a way to get a graph of data in Microft Excel in an instant, and thats not using ALT+I+H+F, but the following:
Select data range and simply press F11 key!
Categories: Microsoft Excel Tags: graph, Instant Graph, microsoft, Microsoft Excel, Quick Graph, Quick Instant Graph
