Google Sheets for Creative Projects and Small Business
Measuring Performance: Date Formulas
A course by Pete Raho , Craftsman and Entrepreneur
Joined March 2022
About the video: Measuring Performance: Date Formulas
Overview
“In this lesson, I will introduce you to some useful formulas to review your performance over weeks and months. I will cover four different time frames: Sales in the last two weeks and the two weeks before that, as well as sales in the last 30 days and the 30 days before that. ”
In this video lesson Pete Raho addresses the topic: Measuring Performance: Date Formulas, which is part of the Domestika online course: Google Sheets for Creative Projects and Small Business. Learn to create effective solutions for your projects or business using spreadsheets to manage your tasks, budget, and sales using its tools and formulas.
Partial transcription of the video
“ Measuring Performance: Date Formulas We've talked about the performance of our business in a couple of ways. Now, we'll use some date formulas to see how it has progressed over the last couple of weeks and months. We'll look at how much we've sold in the past two weeks, say, these 14 days over here, and then we'll look at how much we sold in the past 14 days before that, the two weeks before that. Say, this week over here, going back to this bit over here. After seeing the performance of how we did in the previous two weeks and the two weeks before that, we'll see how we've done in the pr...”
This transcript is automatically generated, so it may contain mistakes.
Course summary for: Google Sheets for Creative Projects and Small Business
-
Category
Marketing & Business -
Software
Google Sheets -
Areas
Business, Management & Productivity

Pete Raho
A course by Pete Raho
Pete Raho is a craftsman and entrepreneur based in Brooklyn, New York. Throughout his carer, he’s enjoyed bringing order to chaos by implementing his problem-solving skills in each role he’s taken on. During his undergrad at Fordham University in New York, he majored in both Art History and Biology, which has allowed him to be both creative and analytical. He also earned his MBA from New York University's Stern School of Business, specializing in Strategy.
Working as a client development analyst at the renowned Christie’s auction house for nearly a decade. He ran his own woodworking business, Gowanus Furniture, creating smart design for compact spaces. Peter was also a business analyst for the furniture retailer, West Elm. Currently, he's working in the world of audio equipment, buying and selling high-end audio tools at StereoBuyers.
- 100% positive reviews (88)
- 7,195 students
- 16 lessons (1h 56m)
- 22 additional resources (14 files)
- Online and at your own pace
- Available on the app
- Audio: English
- English · Spanish · Portuguese · German · French · Italian · Polish · Dutch
- Level: Beginner
- Unlimited access forever