Microsoft Office Tutorials and References
In Depth Information
Extended Date Functions
Figure 10-8: The Extended Date functions used in formulas.
The functions are surprisingly simple. For example, here’s the listing for the XDATE function:
Function XDATE(y, m, d, Optional fmt As String) As String
If IsMissing(fmt) Then fmt = “Short Date”
XDATE = Format(DateSerial(y, m, d), fmt)
End Function
The arguments for XDATE are
h y : A four-digit year in the range 0100 to 9999
h m : A month number (1–12)
h d : A day number (1–31)
h fmt : (Optional) A date format string
If the fmt argument is omitted, the date is displayed using the system’s short date setting (as
specified in the Windows Control Panel).
 
Search JabSto ::




Custom Search