How to create a Mini Calendar in Google Sheets - Tutorial - Days Until Christmas Tracker

thinklikeagirlboss β€’ December 1, 2022
Video Thumbnail

About

No channel description available.

Video Description

In this tutorial I'll show you how to create a Mini Calendar in Google Sheets, while we make a "Days Until Christmas Tracker" at the same time. You can follow it any year, even if we're nowhere near Christmas! I'll teach you the formula that will help you automate your tracker so that your calendar works with any year. I'll also use conditional formatting to create some functionalities like the scratching of days in the calendar all the way up to Christmas Day. I hope you like it! πŸ˜ŠπŸ‘©πŸ»β€πŸ’»βœ¨ πŸ“Œ Link to the FREE Google Sheets File: https://tinyurl.com/38xx9z43 Please note: The template is sent automatically to your email (don’t forget to check your promotions folder). It should arrive within a few minutes, if it doesn’t please send an email to [email protected] πŸ“Œ Link to The Very Merry Christmas Planner video: https://youtu.be/8oJkCIMfv-s πŸ“Œ Link to Shop The Very Merry Christmas Planner: https://thinklikeagirlboss.etsy.com/listing/1562041483/christmas-gift-tracker-christmas-budget Thank you so much for watching!! #googlesheets #tutorial #calendar #planner

Charge Ahead with These Picks

AI-recommended products based on this video

Loading...
soundcore P31i by Anker, Real-Time Adaptive Noise Cancelling, Hi-Res Sound, Translation Earbuds, 50H Playtime, Wireless Earbuds, Bluetooth Earphones, Spatial Audio, Fast Charging, IP55 ClimatePartner certified

soundcore P31i by Anker, Real-Time Adaptive Noise Cancelling, Hi-Res Sound, Translation Earbuds, 50H Playtime, Wireless Earbuds, Bluetooth Earphones, Spatial Audio, Fast Charging, IP55 ClimatePartner certified

(105)
$39.99
FREE delivery Thu, Nov 27
Loading...
Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

(656)
$49.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
2025 Newest WiFi Extender, WiFi Repeater, WiFi Booster, Covers Up to 10000 Sq.ft and 60 Devices, Internet Booster - with Ethernet Port, Quick Setup, Home Wireless Signal Booste

2025 Newest WiFi Extender, WiFi Repeater, WiFi Booster, Covers Up to 10000 Sq.ft and 60 Devices, Internet Booster - with Ethernet Port, Quick Setup, Home Wireless Signal Booste

(335)
$21.99$12.98
FREE delivery Sun, Sep 7 on your first order
1K+ bought in past month
Loading...
Lightning to 3.5mm Audio Jack Adapter Apple MFi Certified iPhone Headphone Jack Adapter Lightning to Aux Adaptor Dongle for iPhone 14 13 12 11 XS XR X 8 7 2 Pack

Lightning to 3.5mm Audio Jack Adapter Apple MFi Certified iPhone Headphone Jack Adapter Lightning to Aux Adaptor Dongle for iPhone 14 13 12 11 XS XR X 8 7 2 Pack

(40)
$10.79
Prime
500+ bought in past month
Loading...
[Apple MFi Certified] Lightning to HDMI Adapter for iPhone, 1080P Digital AV Adapter iPhone HDMI Adapter Video HDMI Sync Screen Connector Compatible with iPhone 14/13/12/X/8 NO Need Power Supply

[Apple MFi Certified] Lightning to HDMI Adapter for iPhone, 1080P Digital AV Adapter iPhone HDMI Adapter Video HDMI Sync Screen Connector Compatible with iPhone 14/13/12/X/8 NO Need Power Supply

(431)
$15.29
FREE delivery Fri, Oct 3 on your first order
500+ bought in past month
Loading...
USBC Charger Block for iPhone 16 Charging Plug,MFI Certified Fast USB C Wall Cube 2Pack Power Adapter for iPhone 15/16 Pro/Plus/Pro Max/14/13/12/11,for iPad Air/Mini USB-C Charge Brick Box

USBC Charger Block for iPhone 16 Charging Plug,MFI Certified Fast USB C Wall Cube 2Pack Power Adapter for iPhone 15/16 Pro/Plus/Pro Max/14/13/12/11,for iPad Air/Mini USB-C Charge Brick Box

(6,878)
$13.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
INIU USB C Charger Block, 100W 3-Port PD Fast Charging, Advanced GaN Power Adapter, Foldable Charger with USB C Cable for MacBook Air 13 Pro, iPad, iPhone 17 16 Pro Max, Samsung S25 S24, Switch 2 etc ClimatePartner certified

INIU USB C Charger Block, 100W 3-Port PD Fast Charging, Advanced GaN Power Adapter, Foldable Charger with USB C Cable for MacBook Air 13 Pro, iPad, iPhone 17 16 Pro Max, Samsung S25 S24, Switch 2 etc ClimatePartner certified

(804)
$36.99
FREE delivery Fri, Feb 13
1K+ bought in past month
Loading...
INIU USB C Charger Block, 100W 3-Port PD Fast Charging, Advanced GaN Power Adapter, Foldable Charger with USB C Cable for MacBook Air 13 Pro, iPad, iPhone 17 16 Pro Max, Samsung S25 S24, Switch 2 etc ClimatePartner certified

INIU USB C Charger Block, 100W 3-Port PD Fast Charging, Advanced GaN Power Adapter, Foldable Charger with USB C Cable for MacBook Air 13 Pro, iPad, iPhone 17 16 Pro Max, Samsung S25 S24, Switch 2 etc ClimatePartner certified

(804)
$36.99
FREE delivery Fri, Feb 13
1K+ bought in past month
Loading...
EBL 9V Rechargeable Batteries, 5400mWh Lithium Batteries with 1600+ Cycles, 2-Hour USB-C Fast Charge for Smoke Detectors, Fire Alarms, Electric Guitars, 4 Pack

EBL 9V Rechargeable Batteries, 5400mWh Lithium Batteries with 1600+ Cycles, 2-Hour USB-C Fast Charge for Smoke Detectors, Fire Alarms, Electric Guitars, 4 Pack

(0)
$35.99
FREE delivery Tue, Dec 30
Loading...
LISEN USB C Cable 240W - [6.6ft 2Pack] Nylon Braided Type C Cable Fast Charge PD3.1 USBC Fast Charging Data Cord for iPhone 17 16 Pro Max Samsung MacBook Pro,Xbox,iPad Pro/Air, Switch 2

LISEN USB C Cable 240W - [6.6ft 2Pack] Nylon Braided Type C Cable Fast Charge PD3.1 USBC Fast Charging Data Cord for iPhone 17 16 Pro Max Samsung MacBook Pro,Xbox,iPad Pro/Air, Switch 2

(7,293)
$16.13
Prime
2K+ bought in past month
Loading...
Multi Charging Cable, Multi Charger Cable 3 in 1 Charger Fast Charge Multiple Ends 4FT Braided Universal Charging Cord with USB C Micro Lightning Cord for iPhone iPad Samsung Android Phone Tablet Global Recycled Standard

Multi Charging Cable, Multi Charger Cable 3 in 1 Charger Fast Charge Multiple Ends 4FT Braided Universal Charging Cord with USB C Micro Lightning Cord for iPhone iPad Samsung Android Phone Tablet Global Recycled Standard

(41)
$8.99
FREE delivery Sun, Oct 5 on your first order
600+ bought in past month
Loading...
Tablet Android 15 Tablet-11 Inch FHD Display, 24GB RAM 256GB ROM /2TB TF, T615 Octa-Core AI Tablets, 8000mAh/18W Fast Charge, 5G WiFi & 16MP Camera, TÜV Certified Netflix HD for Streaming/Gaming

Tablet Android 15 Tablet-11 Inch FHD Display, 24GB RAM 256GB ROM /2TB TF, T615 Octa-Core AI Tablets, 8000mAh/18W Fast Charge, 5G WiFi & 16MP Camera, TÜV Certified Netflix HD for Streaming/Gaming

(329)
$288.99$267.13
FREE delivery Wed, Aug 27
500+ bought in past month
Loading...
2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

(31)
$24.69
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
iWALK Magnetic Power Bank for iPhone, 10000mAh Qi2 15W Wireless Power Bank, 30W Powerbank Fast Charging with USB-C Cable, Portable Charger with LED Display for iPhone 16/15/14/13, Android, Black Recycled Claim Standard Blended

iWALK Magnetic Power Bank for iPhone, 10000mAh Qi2 15W Wireless Power Bank, 30W Powerbank Fast Charging with USB-C Cable, Portable Charger with LED Display for iPhone 16/15/14/13, Android, Black Recycled Claim Standard Blended

(87)
$34.99
FREE delivery Sat, Jun 14 on your first order