(Msg. 1) Posted: Thu Sep 04, 2008 11:29 am
Post subject: Macro or formula for dates Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I have a worksheet where cells J5, M5, P5 All the way through AW5 have
dates formatted in the mm/dd/yyyy format. Ideally I want to enter in
the date in the first cell J5 and have the rest of the dates populate
the cells all the way up to cells AW5 is that possible?
(Msg. 2) Posted: Thu Sep 04, 2008 7:44 pm
Post subject: Re: Macro or formula for dates [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
In K5, =IF(NOT(MOD(COLUMN()-COLUMN($J5),3)),H5+1,""), and copy through to
AW5
--
__________________________________
HTH
Bob
"cmatera" <cmatera.RemoveThis@gmail.com> wrote in message
news:e86cd336-57b5-4d69-92f5-ca33dc3c6620@a8g2000prf.googlegroups.com...
>I have a worksheet where cells J5, M5, P5 All the way through AW5 have
> dates formatted in the mm/dd/yyyy format. Ideally I want to enter in
> the date in the first cell J5 and have the rest of the dates populate
> the cells all the way up to cells AW5 is that possible?
>
> Thanks
>
> Chris
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum