DateAdd Help

abktw2

New Member
Joined
Jul 17, 2008
Messages
15
Hello,

I am looking to create a macro that will look through column BJ which has a series of date in it. I need it to select any row that the cell in column BJ is 30 days before today then cut those selections. I am just gettting familiar with the DateAdd function, but it is taking some time.

Adam
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

abktw2

New Member
Joined
Jul 17, 2008
Messages
15
Sorry one more thing. If it could just select cells in that row between A:BJ it would be more helpful than the entirerow command.
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
You shouldn't really need the dateadd function...

Try

If Date - Range("BJ1") >=30 Then...
 

abktw2

New Member
Joined
Jul 17, 2008
Messages
15
Jonmo-

I am sorry I should have been more detailed. I am still very new to this whole VBA thing. I am trying to teach myself out of a book (poorly written mind you) and am not sure how to start it or what the if statement would be.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,777
Messages
5,470,714
Members
406,719
Latest member
ensbana

This Week's Hot Topics

Top