I have a workbook that I created that has a column containing dates. These
dates are due dates. I would like to write a procedure to execute on workbook
open that will check these dates. I have written the code that will iterate
through each row in the column in each worksheet. Now I am trying to figure
out how to write this sub to do the following but I am not sure of the syntax.

If dueDate <= 30 days from now Then
send email
End If

I am just not familiar with working with dates in Excel. Does anyone have
any suggestions?
Thanks
End If

Hi Samual,

Just need to confirm exactly what is required.

If dueDate <= 30 days from now

Dates that are less than now like last month would be included in that kind
of statement. Is that what you want? In VBA Date is today's date so if that
is what you want then:-

If DueDate <= Date + 30 Then

--
Regards,

OssieMac


"Samuel Looney" wrote:

I have a workbook that I created that has a column containing dates. These
dates are due dates. I would like to write a procedure to execute on workbook
open that will check these dates. I have written the code that will iterate
through each row in the column in each worksheet. Now I am trying to figure
out how to write this sub to do the following but I am not sure of the syntax.

If dueDate <= 30 days from now Then
send email
End If

I am just not familiar with working with dates in Excel. Does anyone have
any suggestions?
Thanks
End If

Samuel;

If you have no experience with working with dates in VBA/Excel, I recommend
you study the subject.
I don't know were you live, but VBA is English/US and your regional settings
in Excel might be different.

I live in the Netherlands and we write dates in this order: DD/MM/YYYY
9/11, the most globally known date at the moment, is written down here as
11/09/2001.

Mind you, there are still people here who interpret this day as the ninth of
November, because of the 9/11 figure !!!

I can recommend David McRitchey's site about dates and time in Excel.
Good luck.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (Those who live some 18 feet below sea level)
--
E:
W: www.spreadsheetsolutions.nl
--
"Samuel Looney" wrote in message
...
I have a workbook that I created that has a column containing dates. These
dates are due dates. I would like to write a procedure to execute on
workbook
open that will check these dates. I have written the code that will
iterate
through each row in the column in each worksheet. Now I am trying to
figure
out how to write this sub to do the following but I am not sure of the
syntax.

If dueDate <= 30 days from now Then
send email
End If

I am just not familiar with working with dates in Excel. Does anyone have
any suggestions?
Thanks
End If

Check out example 2 here
http://www.rondebruin.nl/mail/folder3/message.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Samuel Looney" wrote in message ...
I have a workbook that I created that has a column containing dates. These
dates are due dates. I would like to write a procedure to execute on workbook
open that will check these dates. I have written the code that will iterate
through each row in the column in each worksheet. Now I am trying to figure
out how to write this sub to do the following but I am not sure of the syntax.

If dueDate <= 30 days from now Then
send email
End If

I am just not familiar with working with dates in Excel. Does anyone have
any suggestions?
Thanks
End If