Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time calculation
I have a datasheet with a number of columns, the first of which is date in
the format xx.xx.xxxx. I want to be able to work out which entries are over 14 days old and and send them an email based on another column. I have tried the code as follows- For j = 1 To lastcell If Cells(j, 13) < "" And Cells(j, 14) = "" And Cells(j, 1).Value (Now() - 14) And Cells(j, 15) = "" Then do something next j endif The code to display the email works ok so I have omitted it, however it sends an email to all even though they are less than 14 days old. Obviously it is the And Cells(j, 1).Value (Now() - 14) which is wrong Can someone please help, I have been trying to figure this out for 4 hours now! Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Time | Excel Programming | |||
Stop time - start time calculation | Excel Worksheet Functions | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time calculation with military time | Excel Worksheet Functions |