Thread: Date Formula
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Date Formula

On Tue, 26 Feb 2008 23:24:50 -0500, "T. Valko" wrote:

Improvement:

A1 = 5/5/2008 (m/d/y)
Enter this formula in A2:
=DATE(YEAR(A$1),MONTH(A$1),DAY(A$1-1)+CEILING(ROWS(A$1:A2)/5,1))


The formula can be reduced to:

=A$1-1+CEILING(ROWS(A$1:A2)/5,1)


The OP requested to return only Weekdays (as did the OP's formula). Your
suggestions also return Saturdays and Sundays.
--ron