How to Calculate YTD (Year to Date) Values in Excel using the SCAN function

Leila Gharani • November 4, 2021

Leila Gharani

View Channel

About

No channel description available.

Latest Posts

Python in Excel: The Smarter Way to Use External Data

Leila Gharani

You're ONE DOT Away from Cleaner Excel Reports | Before vs. After TRIMRANGE

Leila Gharani

Excel GROUPBY Hacks to Instantly Improve Your Reports!

Leila Gharani

Who Knew Excel has 2 Hidden QR code Makers (Python is one)

Leila Gharani

Can't-Miss iPhone Accessories

AI-recommended products based on this video

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

(1,577)

$12.99

FREE delivery Sat, Jun 14 on your first order

100+ bought in past month

FNTCASE for iPhone 12 Case: iPhone 12 Pro Case Clear Slim Shockproof Cell Phone Protective Cover | Anti Yellowing Scratch Proof Drop Proof Tough 5G Mobile Phone Protection Bumper 6.1 inch Global Recycled Standard

(2,171)

$7.19

FREE delivery Sat, Jun 14 on your first order

50+ bought in past month

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)

$12.99

FREE delivery Sat, Jun 14 on your first order

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

(81)

$9.99

FREE delivery Sat, Jun 14 on your first order

50+ bought in past month

Yarxiawin Phone Case for Samsung S25 Case with Ring Stand Magnetic Compatible with Magsafe Wireless Charger, Pink Bumper Cover Samsung Galaxy S25 Case Clear Shockproof (Blue)

(0)

$20.23

FREE delivery Sat, Jun 14 on your first order

AsperX for Magsafe Power Bank, 10000mAh Wireless Magnetic Power Bank, 22.5W Wire Fast Charging Portable Charger with USB C Cable, LCD Display for Magsafe Battery Pack for iPhone 16/15/14/13/12

(741)

$49.98

FREE delivery Sun, Aug 10

500+ bought in past month

Wireless Charging Case for AirPods Pro 1st / 2nd Gen with Type-C Charging Port, Compatible with AirPod Pro 2nd Generation Replacement Case, with Blue-Tooth Sync Button, No Earbuds

(15)

$42.98

PrimeFREE delivery Sat, Jun 14

Best Seller

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

(9,766)

$9.89

FREE delivery Sat, Jun 14 on your first order

500+ bought in past month

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

(26,678)

$259.99$194.99

FREE delivery Wed, Aug 20

5K+ bought in past month

Wireless Charger, 3 in 1 Charging Station, Fast Charging Station Foldable Charging Stand, Wireless Charging Station for Multiple Devices, Compatible with lPhone 16/15/14/13 Pro Max Airpods Watch

(208)

$28.99

FREE delivery Mon, Jul 7 on your first order

1K+ bought in past month

Best Seller

Kaiess 62" Tripod for iPhone, Selfie Stick Tripod & Phone Tripod Stand with Remote, Cell Phone Tripod for iPhone, Extendable Travel Tripod Compatible with iPhone 14/13/12 Pro Max/Android

(5,298)

$28.98

FREE delivery Sat, Jun 14 on your first order

1K+ bought in past month

EUCOS 62" Phone Tripod, Tripod for iPhone & Selfie Stick Tripod with Remote, Extendable Phone Tripod Stand & Travel Tripod, Solidest Cell Phone Tripod Compatible with iPhone/Android

(13,783)

$28.99

Prime

5K+ bought in past month

NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

(2,807)

$181.49

FREE delivery Sun, Aug 10

Phone Mount for Tripod, Adjustable Phone Tripod Mount with Cold Shoe & Arca Swiss Quick Release Plate,Universal Adjustable Clamp Suitable for iPhone 14 pro/13 Pro/12/11/Samsung

(394)

$48.12$43.08

FREE delivery Jun 18 - 20

ESR Camera Lens Protector for iPhone 16/16 Plus, Tough HD Individual Protectors, Scratch Resistant, Ultra-thin Tempered Glass, Armorite Series, 1 Pack, Clear

(3,839)

$7.99

FREE delivery Sat, Jun 14 on your first order

100+ bought in past month

[2+2] LK 2 Pack Compatible for iPhone 16 Screen Protector + 2 Pack Camera Lens Protector, Tempered Glass Film, Ultra HD, 9H Hardness, Bubble Free, Easy Installation, Case Friendly

(66,622)

$13.99

FREE delivery Sat, Jun 14 on your first order

100+ bought in past month

Ailun 3 Pack Screen Protector for iPhone 16 [6.1 inch] + 3 Pack Camera Lens Protector with Installation Frame,Case Friendly Tempered Glass Film,[9H Hardness] - HD

(140,836)

$9.34

FREE delivery Sat, Jun 14 on your first order

3K+ bought in past month

[3+3 Pack] iVoler Tempered Glass for iPhone 14 6.1 inch [3 Pack] with [3 Pack] Camera Lens Screen Protector with [Alignment Frame], Anti-Scratch Case Friendly Transparent HD Clear Film

(36,815)

$11.99

FREE delivery Sat, Jun 14 on your first order

200+ bought in past month

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

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

AINOPE Phone Holder for Car Vent 2025 Gravity Air Vent Car Phone Holder Mount for iPhone 16 Pro Max with Vent Clip Hand Free Cell Phone Car Mount for iPhone 16 Plus Samsung S25 Ultra Car Accesorries

(29,179)

$19.99$18.17

FREE delivery Tue, Jun 17 on your first order

2K+ bought in past month

Best Seller

Miracase Phone Holders for Your Car, Multifunctional Car Phone Holder with Suction Cup Base, Hands Free Universal Cell Phone Car Mount, Automobile Phone Mount Car for iPhone Android Smartphones(Base)

(11,031)

$21.99

FREE delivery Tue, Jun 17 on your first order

2K+ bought in past month

Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

(128)

$21.99

FREE delivery Tue, Jun 17 on your first order

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)

$12.99

FREE delivery Sat, Jun 14 on your first order

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

(81)

$9.99

FREE delivery Sat, Jun 14 on your first order

50+ bought in past month

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

(1,577)

$12.99

FREE delivery Sat, Jun 14 on your first order

100+ bought in past month

FNTCASE for iPhone 12 Case: iPhone 12 Pro Case Clear Slim Shockproof Cell Phone Protective Cover | Anti Yellowing Scratch Proof Drop Proof Tough 5G Mobile Phone Protection Bumper 6.1 inch Global Recycled Standard

(2,171)

$7.19

FREE delivery Sat, Jun 14 on your first order

50+ bought in past month

USB C Fast Wall Charger for iPhone/iPad, 20W Type C Power Adapter Fast Charging Block for iPhone 16/16e/16 Plus/16 Pro/16 Pro Max/15/14/13/12/11/XS/XR/X/8 Plus, iPad Pro/Air/Mini, Pixel 9, Galaxy S25

(503)

$9.78

FREE delivery Sat, Jun 14 on your first order

500+ bought in past month

USB C Charger Block, 40W Dual USB C Wall Charger PD+QC USB Wall Plug Multiport Type C Power Adapter Fast Charging Block for iPhone 15 14 13 12 iPad Galaxy S23 S22 Pixel LG Tablet Android

(20,603)

$15.99

FREE delivery Sat, Jun 14 on your first order

4K+ bought in past month

UGREEN 130W Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging Car Adapter with 100W USB C Cable Compatible with Dell XPS, MacBook, iPhone 16 15 14 Pro Max, Galaxy S25 S24 Ultra, iPad Pro

(4,725)

$31.99

500+ bought in past month

Best Seller

45W Charger for Nintendo Switch, AC Power Adapter for Switch, Fast Charging Power Supply Compatible with Switch OLED/Lite/Steam Deck Dock, Support TV Mode, 15V 2.6A (5ft)

(262)

$19.99

FREE delivery Tue, Jun 17 on your first order

500+ bought in past month

Hand Warmers 2 Pack, 14000mAh Rechargeable Hand Warmers, Electric Hand Warmer Reusable, Portable Power Bank USB Hand Warmers 4 Levels 8 Heating, Gifts for Raynauds Ski Golf Camping

(683)

$74.08$59.47

FREE delivery Jun 13 - 18

Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels & Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids

(651)

$44.99

PrimeFREE delivery Sun, Jun 15

Amazon's Choice

2Pack Rechargeable Hand Warmer, 8000mAh Electric Hand Warmer Power Bank, Portable USB-C Hand Warmer for Pocket, Reusable Hand Warmer Up to 8 hrs Each, Warm Gift for Men Women, for Hunting, Camping

(1,128)

$15.99

FREE delivery Sat, Jun 14 on your first order

Wireless Power Bank 40800mAh,7-in-1 Portable Charger with 3 Built in Cables,15W Wireless Charging 25W PD QC 4.0 Fast Charging USB C LCD Display Battery Pack for iPhone 16/15/13/12,Samsung,Android etc

(65)

$56.95

FREE delivery Tue, Aug 12

200+ bought in past month

How to Calculate YTD (Year to Date) Values in Excel using the SCAN function

Leila Gharani

About

Latest Posts

Python in Excel: The Smarter Way to Use External Data

You're ONE DOT Away from Cleaner Excel Reports | Before vs. After TRIMRANGE

Excel GROUPBY Hacks to Instantly Improve Your Reports!

Who Knew Excel has 2 Hidden QR code Makers (Python is one)

You May Also Like

Can't-Miss iPhone Accessories

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

FNTCASE for iPhone 12 Case: iPhone 12 Pro Case Clear Slim Shockproof Cell Phone Protective Cover | Anti Yellowing Scratch Proof Drop Proof Tough 5G Mobile Phone Protection Bumper 6.1 inch Global Recycled Standard

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

Yarxiawin Phone Case for Samsung S25 Case with Ring Stand Magnetic Compatible with Magsafe Wireless Charger, Pink Bumper Cover Samsung Galaxy S25 Case Clear Shockproof (Blue)

AsperX for Magsafe Power Bank, 10000mAh Wireless Magnetic Power Bank, 22.5W Wire Fast Charging Portable Charger with USB C Cable, LCD Display for Magsafe Battery Pack for iPhone 16/15/14/13/12

Wireless Charging Case for AirPods Pro 1st / 2nd Gen with Type-C Charging Port, Compatible with AirPod Pro 2nd Generation Replacement Case, with Blue-Tooth Sync Button, No Earbuds

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

Wireless Charger, 3 in 1 Charging Station, Fast Charging Station Foldable Charging Stand, Wireless Charging Station for Multiple Devices, Compatible with lPhone 16/15/14/13 Pro Max Airpods Watch

Kaiess 62&quot; Tripod for iPhone, Selfie Stick Tripod &amp; Phone Tripod Stand with Remote, Cell Phone Tripod for iPhone, Extendable Travel Tripod Compatible with iPhone 14/13/12 Pro Max/Android

EUCOS 62&quot; Phone Tripod, Tripod for iPhone &amp; Selfie Stick Tripod with Remote, Extendable Phone Tripod Stand &amp; Travel Tripod, Solidest Cell Phone Tripod Compatible with iPhone/Android

NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

Phone Mount for Tripod, Adjustable Phone Tripod Mount with Cold Shoe &amp; Arca Swiss Quick Release Plate,Universal Adjustable Clamp Suitable for iPhone 14 pro/13 Pro/12/11/Samsung

ESR Camera Lens Protector for iPhone 16/16 Plus, Tough HD Individual Protectors, Scratch Resistant, Ultra-thin Tempered Glass, Armorite Series, 1 Pack, Clear

[2+2] LK 2 Pack Compatible for iPhone 16 Screen Protector + 2 Pack Camera Lens Protector, Tempered Glass Film, Ultra HD, 9H Hardness, Bubble Free, Easy Installation, Case Friendly

Ailun 3 Pack Screen Protector for iPhone 16 [6.1 inch] + 3 Pack Camera Lens Protector with Installation Frame,Case Friendly Tempered Glass Film,[9H Hardness] - HD

[3+3 Pack] iVoler Tempered Glass for iPhone 14 6.1 inch [3 Pack] with [3 Pack] Camera Lens Screen Protector with [Alignment Frame], Anti-Scratch Case Friendly Transparent HD Clear Film

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

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 &amp; Airpod Global Recycled Standard

AINOPE Phone Holder for Car Vent 2025 Gravity Air Vent Car Phone Holder Mount for iPhone 16 Pro Max with Vent Clip Hand Free Cell Phone Car Mount for iPhone 16 Plus Samsung S25 Ultra Car Accesorries

Miracase Phone Holders for Your Car, Multifunctional Car Phone Holder with Suction Cup Base, Hands Free Universal Cell Phone Car Mount, Automobile Phone Mount Car for iPhone Android Smartphones(Base)

Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

FNTCASE for iPhone 12 Case: iPhone 12 Pro Case Clear Slim Shockproof Cell Phone Protective Cover | Anti Yellowing Scratch Proof Drop Proof Tough 5G Mobile Phone Protection Bumper 6.1 inch Global Recycled Standard

USB C Fast Wall Charger for iPhone/iPad, 20W Type C Power Adapter Fast Charging Block for iPhone 16/16e/16 Plus/16 Pro/16 Pro Max/15/14/13/12/11/XS/XR/X/8 Plus, iPad Pro/Air/Mini, Pixel 9, Galaxy S25

USB C Charger Block, 40W Dual USB C Wall Charger PD+QC USB Wall Plug Multiport Type C Power Adapter Fast Charging Block for iPhone 15 14 13 12 iPad Galaxy S23 S22 Pixel LG Tablet Android

UGREEN 130W Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging Car Adapter with 100W USB C Cable Compatible with Dell XPS, MacBook, iPhone 16 15 14 Pro Max, Galaxy S25 S24 Ultra, iPad Pro

45W Charger for Nintendo Switch, AC Power Adapter for Switch, Fast Charging Power Supply Compatible with Switch OLED/Lite/Steam Deck Dock, Support TV Mode, 15V 2.6A (5ft)

Hand Warmers 2 Pack, 14000mAh Rechargeable Hand Warmers, Electric Hand Warmer Reusable, Portable Power Bank USB Hand Warmers 4 Levels 8 Heating, Gifts for Raynauds Ski Golf Camping

Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels &amp; Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids

2Pack Rechargeable Hand Warmer, 8000mAh Electric Hand Warmer Power Bank, Portable USB-C Hand Warmer for Pocket, Reusable Hand Warmer Up to 8 hrs Each, Warm Gift for Men Women, for Hunting, Camping

Wireless Power Bank 40800mAh,7-in-1 Portable Charger with 3 Built in Cables,15W Wireless Charging 25W PD QC 4.0 Fast Charging USB C LCD Display Battery Pack for iPhone 16/15/13/12,Samsung,Android etc

Loading...

Kaiess 62" Tripod for iPhone, Selfie Stick Tripod & Phone Tripod Stand with Remote, Cell Phone Tripod for iPhone, Extendable Travel Tripod Compatible with iPhone 14/13/12 Pro Max/Android

EUCOS 62" Phone Tripod, Tripod for iPhone & Selfie Stick Tripod with Remote, Extendable Phone Tripod Stand & Travel Tripod, Solidest Cell Phone Tripod Compatible with iPhone/Android

Phone Mount for Tripod, Adjustable Phone Tripod Mount with Cold Shoe & Arca Swiss Quick Release Plate,Universal Adjustable Clamp Suitable for iPhone 14 pro/13 Pro/12/11/Samsung

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

Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels & Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids