This is just a quick tip as Excel is not necessarily that date friendly. If you want to calculate an invoice date or a project completion date use the WORKDAY() function. Select a cell and then select the Formula tab and then select Date& Time The syntax is as...
If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and the CountIF feature to check for duplicate entries and then not allow the user to enter the duplicate data. Let’s assume that the data...
