increment dates in alternate cells automatically
Just put the start date in A1, then in C1 add
=IF(MOD(COLUMN(),2)=0,"",IF(MONTH($A1+INT(COLUMN()/2))=MONTH($A1),A1+1,""))
and copy across to B1
--
HTH
RP
(remove nothere from the email address if mailing direct)
"praz" wrote in message
ups.com...
I have date placed in alternate cells for example A1-01/03/05
C1-02/03/05 D1-03/03/05 F1-04/03/05 till ....30/03/05
What I do is fill up these cells manually for every month, basically by
copying
the last months dates into a new worksheet and changing it for the new
month.
Is there a way where i could input a start date and end date on a
particular cell or in dialog box and then execute a macro to fill up
alternate cells for the given range...
Appreciate any help.
Thanks.
Praz
|