How do you find the difference between two dates in Google Sheets? Do you just subtract two dates? Or is there a handy formula you can use to better calculate the difference. In most spreadsheets there is a handy little function called DATEDIF (date dif) which can do more than just find the difference in days between two dates.
Category: Software
Best Set Up For SuiteScript Coding in WebStorm
If you use the excellent WebStorm (or any of the other great IDE’s from JetBrains) to code your SuiteScript, then you’ll want to add the SuiteScript plugin to be able to deploy your code into your NetSuite instance.
Best Editor For Coding SuiteScript Seamlessly
There are several excellent coding editors for SuiteScript programmers to choose from, especially if you’re not too fond of the Eclipse IDE which is the recommended tool of choice within the SuiteScript help documents. In this article I explore other editors and share my personal preference.
How To Fix “Invalid Property Assignment (Error 450)”
What happens when you get the oblique error from Excel VBA that there has been an invalid property assignment (Error 450)? Here’s how I was able to find the solution.
How to Customise Your Mac Using Dot Files
Do you regularly wipe your computer and start over again? I tend to perform this ritual on an annual basis to keep my Mac clean from software I downloaded, but now no longer use. The only hassle with this approach is that each time you reboot into your Mac you need to go through configuring everything again. Not so with this handy little feature, check out dotfiles.
How To Manage WordPress CSS Using Brackets & Dropbox
Before Dropbox made changes to publicly available documents this process worked well in effectively managing your Wordpress stylesheets and JavaScript code. This article may give you some ideas on how you manage your code effectively without Dropbox.
How To Manage Multiple WordPress Sites As A Developer
When starting your new Wordpress site there are a few things you should consider as you develop it besides just writing content and putting up your images. The three questions I explore in this post concern back-ups, managing customisations and optimisations.
How To Insert Equation When Equation Editor Greyed Out
If you want to construct a big juicy equation in your Microsoft Word 2011 for Mac document, but discover you cannot click on the equation editor icon, here’s the simple remedy.
Solved! Explain Everything Powerpoint Issues
If you would like to import your Powerpoint slides into the famous Explain Everything iPad app for screen-casting you should look at these alternative ways if you’ve found (as I have) that there isn’t a seamless transition from your Powerpoint presentation to the way it’s displayed within Explain Everything.
2012 Reflection & Working Environment
At the end of every year it’s good to reflect on what changes you’ve made and why you’ve made them. This helps to be aware of trends and in your own personal development. Here’s how the end of 2012 looked for me.