Macro or formula for dates

C

cmatera

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
 
B

Bob Phillips

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