Date and Time
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: