109. Determining Specific Dates
Published Online: 11 NOV 2011
DOI: 10.1002/9781118257647.ch109
Copyright © 2010 Wiley Publishing, Inc., Indianapolis, Indiana
Book Title
John Walkenbach's Favorite Excel® 2010 Tips & Tricks
Additional Information
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
- Published Online: 11 NOV 2011
- Published Print: 28 JUN 2010
ISBN Information
Print ISBN: 9780470475379
Online ISBN: 9781118257647
- Summary
- Chapter
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