TODAY function in Excel - current date continuously updated
The TODAY function returns the current date. The TODAY function is updated continuously when a worksheet is opened. For example: if you use the TODAY function in cell B1, it will show today's date. Assume that today is 12/21/2021. Tomorrow, it will have the correct date of 12/22/2021. This video will use the TODAY function with an accounting exercise and an HR exercise. I'll also demonstrate Averageif, Countif, and other functions I use with the Today function.
Chris Menard's blog post on the Today Function
https://chrismenardtraining.com/post/...
Chapters:
0:00 Intro
0:55 Today Function
1:58 Countif Function
2:38 Accounting Exercise
4:15 Average & Averageif
5:20 HR data
6:10 DATEDIF - Y
7:44 DATEDIF - YM
8:40 DATEDIF - MD
Excel file used in the video:
https://drive.google.com/drive/folder...
Arguments for TODAY function
The TODAY function takes no arguments.=TODAY() Notice there is nothing between the parentheses. Some functions, such as SUM, AVERAGE, MAX, MIN, and MEDIAN require one argument, or where input is needed.
Examples of Functions with one argument:
=Sum(B2:B12)
=Average(B2:B12)
=MAX(B2:B12
Some functions take multiple arguments. Those functions would include Countif and Large. An example is =Countif(c2:c12,"accounting"). If column C contained departments, the countif would find how many people work in Accounting.
#msexcel #microsoftexcel #todayfunction #chrismenard #chrismenardtraining
Websites:
Chris Menard's website: https://chrismenardtraining.com
Cristian's YouTube Channel: / @graphicious
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!