Macro or formula for dates
 

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

Macro or formula for dates
 

In K5, =IF(NOT(MOD(COLUMN()-COLUMN($J5),3)),H5+1,""), and copy through to
AW5

--
__________________________________
HTH

Bob

"cmatera" wrote in message
...
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