| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add days to date
I want the code to pick dates from column Q (see line 4) add 7 days and put
the new dates into column k. Any suggestions? Sub copy_Dates() Sheets(2).Range("e4:e65536").Value = Sheets(1).Range("d4:d65536") Sheets(1).Range("n4:Q65536").Value = Sheets(2).Range("f4:i65536").Value Sheets(1).Range("k4:K65536").Value = Range("q4:q65536").Value Sheets(1).Select Range("k65536").End(xlUp).Activate If ActiveCell.Value <= Now - 30 Then msgbox "NICE!!" Else: Exit Sub End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to pull <=14 Days, <=30 Days, 30 Days from a date column | Excel Discussion (Misc queries) | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| TWO DATES,150 DAYS APART,NEED ONE DATE TO TURN RED AFTER 150 DAYS | Excel Programming | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Threaded Mode
