Excel Snippets: Series Index

Microsoft ExcelMy knowledge of using Excel is somewhat patchy; there are some things I can do easily and other simple things which I find troublesome. While I might not post many Excel snippets, I’m collecting them into a small series to make them easy to find again in future.

I’ve already been doing similar posts with Network Shell Snippets, PowerShell Snippets and VBA Snippets. The series index will automatically update as posts go live, but if you’re reading a syndicated version, you’ll need to check back to the original post

Excel Snippets
Get first day and last day of month using an Excel formula
Substitute Function
Preserve Decimals in Result of Formula
AND/OR Operators
Generate Row Numbers
Calculate Difference Between Dates
Add n Months to Current Date
Formula to Calculate Monthly Value of a Mortgage with Monthly Interest
Pad Numbers with Leading Zeroes
Offset Formula to Calculate Range on Number
Get First and Last Dates of Calendar Year
Get First and Last Dates of UK Tax Year
Formula to Zero Pad to 6 Digits

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Leave a Reply

Your email address will not be published. Required fields are marked *