Treehouse | Community | The EDATE Function

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Miguel Enriquez
2,057 Points
How to exclude Saturdays and Sundays while using EDATE?

Posted April 2, 2018 5:08am by Miguel Enriquez

Miguel Enriquez
2,057 Points
1 Answer
PLUS

Daniyell Augusta
Courses Plus Student 495 Points
The most expensive item in the "other" category is not Hair Salon?

Posted March 18, 2018 6:00pm by Daniyell Augusta

Daniyell Augusta
Courses Plus Student 495 Points
2 Answers
Kelly Burchfield
579 Points
I've been marked incorrect on a couple simple answers in this quiz. Is this a glitch perhaps?

Posted March 14, 2018 1:04pm by Kelly Burchfield

Kelly Burchfield
579 Points
2 Answers
Hardik Gami
1,622 Points
Here i am getting answer as $318.00 and when i am writing it, it is coming is bummer.. can any one help me with that ?

Posted March 13, 2018 11:30pm by Hardik Gami

Hardik Gami
1,622 Points
1 Answer
PLUS

Matthew Han
Courses Plus Student 701 Points
I arrived at a different answer

Posted February 23, 2018 8:25am by Matthew Han

Matthew Han
Courses Plus Student 701 Points
1 Answer
Misgana Tezera
1,892 Points
In the Expenses spreadsheet you opened in the first question, the least expensive item in the F&B category is

Posted February 20, 2018 8:10pm by Misgana Tezera

Misgana Tezera
1,892 Points
1 Answer
PLUS

Matthew Han
Courses Plus Student 701 Points
How to SUM a filtered spreadsheet column?

Posted February 20, 2018 3:04pm by Matthew Han

Matthew Han
Courses Plus Student 701 Points
1 Answer
PLUS

Matthew Han
Courses Plus Student 701 Points
If we are dealing with thousands of data, we can't possibly select with our mouse when doing the SUM function right?

Posted February 20, 2018 10:45am by Matthew Han

Matthew Han
Courses Plus Student 701 Points
3 Answers
CadenceH Cha
409 Points
I sorted column C into F&B and Entertainment. How can I get the sum of **only** the prices that show in column B?

Posted February 17, 2018 5:32pm by CadenceH Cha

CadenceH Cha
409 Points
1 Answer
David Griffith
8,311 Points
For this question in the test "In the Expenses spreadsheet you opened in the first question, the total dollar value of a

Posted February 9, 2018 7:31pm by David Griffith

David Griffith
8,311 Points
6 Answers
Sean Sarnelli
355 Points
Google Sheet Access

Posted February 7, 2018 8:55pm by Sean Sarnelli

Sean Sarnelli
355 Points
1 Answer
Anish Mathews
844 Points
Your boss asks you to tell her how many employees she needs to have on duty during an event. She needs at least 1 employ

Posted February 3, 2018 12:45am by Anish Mathews

Anish Mathews
844 Points
1 Answer
ajibola adigun
5,384 Points
The total dollar value of the expenses is $

Posted January 24, 2018 7:28pm by ajibola adigun

ajibola adigun
5,384 Points
1 Answer
Alex Life
16,114 Points
Why is this quiz giving me "incorrect" when im right?

Posted December 16, 2017 5:15pm by Alex Life

Alex Life
16,114 Points
1 Answer
mike john
3,719 Points
I can't find an efficient Inventory management template.! Please help..!

Posted December 10, 2017 7:15am by mike john

mike john
3,719 Points
1 Answer
Jan Lundeen
6,121 Points
On Spreadsheet Basics Final quiz, I used SUM function to answer question 1 of 6. Where did I go wrong?

Posted November 9, 2017 5:37am by Jan Lundeen

Jan Lundeen
6,121 Points
1 Answer
Eni Begotaraj
13,723 Points
How to do Average on filtered items on google sheets?

Posted October 12, 2017 3:27pm by Eni Begotaraj

Eni Begotaraj
13,723 Points
1 Answer
A X
12,842 Points
He lost me at absolute referencing...

Posted September 2, 2017 2:29am by A X

A X
12,842 Points
2 Answers
A X
12,842 Points
Michael mentions a "specialized software" that does inventory management. What is this?

Posted August 26, 2017 8:18pm by A X

A X
12,842 Points
1 Answer
Kristy Knapp
10,632 Points
Google Sheets "Paste Special > Transpose" greyed out

Posted August 26, 2017 3:49am by Kristy Knapp

Kristy Knapp
10,632 Points
3 Answers
Lee Ravenberg
10,019 Points
I can't figure out how to reference a how to reference all cells in column C that yields the value of 'other'.

Posted August 21, 2017 2:57pm by Lee Ravenberg

Lee Ravenberg
10,019 Points
1 Answer
John Grillo
30,241 Points
The total number of fish which passed through the dam in 2001 was

Posted August 20, 2017 7:28pm by John Grillo

John Grillo
30,241 Points
1 Answer
syalih
16,468 Points
Spreadsheets and Functions and Shortcuts Quiz 2?

Posted July 31, 2017 9:11am by syalih

syalih
16,468 Points
3 Answers
Sunitha Chilukuri
137 Points
USE THE SUMIF FUNCTION TO CALCULATE THE TOTAL EXPENSES OF F&B

Posted July 17, 2017 6:02pm by Sunitha Chilukuri

Sunitha Chilukuri
137 Points
2 Answers
Robert Howard
4,926 Points
How can I pass the Spreadsheet quiz if the answers are wrong, or require a format that I cannot figure out?

Posted July 14, 2017 1:59am by Robert Howard

Robert Howard
4,926 Points
2 Answers
djdinosauripod
356 Points
Go to row option/hotkey?

Posted July 3, 2017 4:45pm by djdinosauripod

djdinosauripod
356 Points
1 Answer
John Tilton
2,243 Points
Right Answer is NOT Correct

Posted July 3, 2017 1:44am by John Tilton

John Tilton
2,243 Points
2 Answers
agzagi
2,399 Points
Why is it that when I select for the [sum_range] the whole C column, like C:C, it yields a totally different result?

Posted June 16, 2017 3:12pm by agzagi

agzagi
2,399 Points
2 Answers
nfs
35,526 Points
Why is there an error in making a percentage value in column E??

Posted June 13, 2017 2:35pm by nfs

nfs
35,526 Points
2 Answers
Sahar Nasiri
7,454 Points
When I filter a column how can I calculate the total price of that filtering

Posted June 10, 2017 7:32am by Sahar Nasiri

Sahar Nasiri
7,454 Points
1 Answer

Prev Page 4 of 5 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.