All Questions
Tagged with microsoft-excel google-docs
4 questions
1
vote
0
answers
69
views
NETWORKDAYS.INTL Method Changed
Google sheet's NETWORKDAYS.INTL Method supposes to calculate number of working days between two given dates, and consider weekends and holidays.
I use this method a lot in my functions, but today I ...
- 35
0
votes
1
answer
155
views
Check if any cells in one column fall between cells in different columns in Google Sheets
So I'm trying to figure out if any call for service happens during the time frame of another call.
The information is set up below like this:
| |[A]|[B]|[C]|
|:---|:---|:---|:---|
|1|"Call Time&...
- 10k
-1
votes
1
answer
5k
views
Replacing text of links in google sheets
I have a bunch of links in cells in my google sheets. I want to replace all the text of them all just to say "LINK" so that when I click on them it's still hyperlinked to the correct site.
...
- 2,422
-1
votes
1
answer
1k
views
What's the best way to upload a million row spreadsheet as Google spreadsheet? [closed]
I have an Excel spreadsheet with over a million rows that I would like to have as a Google sheet.
I tried uploading the file as a CSV to my Google drive, which worked. Then I tried opening it as a ...
- 5,123