logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Tag: Google Sheets

Warning: Opening Excel Files with Array Formulas in Google Sheets

September 23, 2016 2 comments Article Google Apps, Google Sheets, Intermediate

From time to time, you might have to work with both Excel and Google Sheets interchangeably. Generally, opening fairly standard Excel Files in Google Sheets works fine – Google has strong support for most Excel functions. More complex or large worksheets generally fail to open in Google Sheets – not ideal, but at least there’s no hiding from Read More

Using EOMONTH() to get the First and Last Date of a Given Month in Excel & Google Sheets

July 4, 2016 0 comments Article Easy, Excel

This update shows a quick and simple example of how to use the EOMONTH function to get the first, and last, date of a given month. Read More

Determine if a file is open in Excel or Google Sheets

June 21, 2016 0 comments Article Easy, Excel

We currently use a mixture of Excel and Google Sheets. Not ideal, but it’s important that any output I create can behave with both platforms, there are inherent differences in the platforms. Some of these differences simply can’t be accommodated for. Others, however, can be worked around From time to time, I need my document Read More

Using TEXTJOIN and CONCATENATE for combining Text Strings in Excel

March 31, 2016 1 comment Article Easy, Excel

Learn about the different techniques for joining Text Strings in Excel, including the excellent new TEXTJOIN function Read More

Using NETWORKDAYS to calculate the number of business days between two dates in Excel

March 14, 2016 0 comments Article Excel, Intermediate

NETWORKDAYS (That’s Net Work Days, not Network Days) is a versatile spreadsheet function that lets you calculate working days between two dates, allowing for weekends, public holidays and more. Read More

Most Read Articles

Using the IFS() and SWITCH() Functions to test for more than one condition in Excel 2016
Populate a table by looping through items in a list / another table
Format or Remove Borders from a Slicer or Timeline in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Showing Data Bars as a 'Proportion to Total' in Excel

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2022 - Theme by ThemeinProgress