WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Macro or formula for dates

 
   Home -> Office -> Worksheet Functions RSS
Next:  Excel formula questin  
Author Message
cmatera

External


Since: May 19, 2008
Posts: 19



(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?

Thanks

Chris
Back to top
Login to vote
Bob Phillips

External


Since: Jun 16, 2008
Posts: 916



(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
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> Worksheet Functions 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
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET