Microsoft Office Tutorials and References
In Depth Information
Figure 6-3: Using Excel's AutoFill feature to create a series of dates.
To generate a series of dates separated by one year, use this formula:
To generate a series of weekdays only (no Saturdays or Sundays), use the formula that follows. This formula as-
sumes that the date in cell A1 is not a weekend day:
Converting a non-date string to a date
You may import data that contains dates coded as text strings. For example, the following text represents
August 21, 2013 (a four-digit year followed by a two-digit month, followed by a two-digit day):
Search JabSto ::

Custom Search