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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top