Скачать или смотреть How to use the TODAY function in Excel

The TODAY function returns the current date and is updated automatically when you open an Excel file. The TODAY function has no arguments. In this video, I'll use the TODAY function in an accounting exercise using Accounts Receivable. You would use the same for Accounts Payable. I also use Absolute reference with Net 30 terms. The TODAY function would be used for HR if you are trying to calculate years of service for your employees.

Chapters:
0:00 Intro
0:30 Net 30 days
0:55 TODAY w/ Absolute ref
1:40 Days overdue
2:25 AVERAGEIF Function

Chris Menard's blog post
https://chrismenardtraining.com/post/...

Examples of the TODAY function
=TODAY() returns the current date
=TODAY()+5 returns 5 days from today
=TODAY()-2 returns 2 days in the past

And make sure you subscribe to my channel!

- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!