109. Determining Specific Dates

  1. John Walkenbach

Published Online: 11 NOV 2011

DOI: 10.1002/9781118257647.ch109

John Walkenbach's Favorite Excel® 2010 Tips & Tricks

John Walkenbach's Favorite Excel® 2010 Tips & Tricks

How to Cite

Walkenbach, J. (2010) Determining Specific Dates, in John Walkenbach's Favorite Excel® 2010 Tips & Tricks, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257647.ch109

Publication History

  1. Published Online: 11 NOV 2011
  2. Published Print: 28 JUN 2010

ISBN Information

Print ISBN: 9780470475379

Online ISBN: 9781118257647

SEARCH

Keywords:

  • specific dates;
  • day of the week;
  • formulas;
  • weekday function;
  • date serial number

Summary

This chapter contains sections titled:

  • Determining the day of the year

  • Determining the day of the week

  • Determining the date of the most recent Sunday

  • Determining the first day of the week after a date

  • Determining the nth occurrence of a day of the week in a month

  • Determining the last day of a month

  • Determining a date's quarter