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
|