- Category: Date and Time Date and Time
- Published: 13 March 2009 13 March 2009
- Last Updated: 31 August 2011 31 August 2011
Displaying specific dates
To display specific dates, you can use the DateSerial() function to manipulate the day, month, and year portions of a date.
The syntax for the DateSerial function is:
DateSerial( year, month, day )
year is a numeric value between 100 and 9999 that represents the year value of the date.
month is a numeric value that represents the month value of the date.
day is a numeric value that represents the day value of the date.
TRICK: By setting the day value to zero it will return the date that is the last day of the previous month .
Example Date calculations: