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
How to Reveal File Extensions on your Windows PC
If you have a PC for a while there may come a point were you need to see your file extensions. For those not familiar with what a file extension is, its the 3 or 4 alphanumeric characters proceeding the dot (or ‘period’ ), e.g. for Microsoft Word document files can end in .doc, or .docx, the doc and the docx are the file extensions. Other common file extensions include .jpg, .mp3, .gif.
So this how do you go about getting your PC to reveal them:
Open My Computer, go to the Tools menu and scroll down to Folder Options… select the View tab. Under Advanced settings, uncheck the check box for Hide extensions for known file types, then press the OK button to confirm the change.
Categories: Computers, General Tags: alphanumeric characters, doc, docx, extension, file, file extension, file extensions, file extention, gif, Hide extensions for known file types, jpg, microsoft, microsoft word document, mp3, ok button, pc, windows pc, word document files
