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:
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
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:
=IF(WEEKDAY(A1)=6,A1+3,A1+1)
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