Excel Magic Trick 848: Create List of Dates For Month With Formula

ExcelIsFun

  • Currently 0.00/5
  • 1
  • 2
  • 3
  • 4
  • 5
Rating: 0.0 out of 0 votes
Comments (0)

Refresh page if video doesn't load!!! Download Video Excel Magic Trick 848: Create List of Dates For Month With Formula

You need to have the Flash Player installed and a browser with JavaScript support.


Lights off
Sorry, your favorites list is FULL.

Link to this video

Description

Learn how to:
1. Given the month as text and the year as a number, see how to get the first of the month and the last of the month and a list of dates for the month.
2. Learn about the YEAR, MONTH, EOMONTH, IF, ROWS and DAY functions.
3. See how to extract the month as a number from the month given as text using the MONTH function and ampersand one&1

Tags



Comments

Be the first to comment

Sign in or sign up to post comments.
Artist: ExcelIsFun
Video title: Excel Magic Trick 848: Create List of Dates For Month With Formula
Category: Education
Views: 834
Submitted by: admin