I need a formula to distribute 3 days per year evenly. I have a cell with
the start date this include month, day and year. I want to distribute the
day every 4 month starting with the month in the start date. any suggestion?
--
KK

"KANDLEZ" wrote:
I need a formula to distribute 3 days per year evenly. I have a cell with
the start date this include month, day and year. I want to distribute the
day every 4 month starting with the month in the start date.

With Startdate in A2
Place in B2: =DATE(YEAR($A2),MONTH($A2)+4*COLUMNS($A:A),DAY($A2 ))
Copy across to C2

Or, if you really want that startdate in A2 to be reflected in B2
Then in B2, copied across to D2:
=DATE(YEAR($A2),MONTH($A2)+4*COLUMNS($A:A)-4,DAY($A2))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---