Thread: Dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick S. Rick S. is offline
external usenet poster
 
Posts: 213
Default Dates

I could use some help, I have a scenerio that I need to determine when a date
falls near the 2nd day of a month or the last day of the month. I have read
info from Mr. Pearson's site that makes my head hurt but not necessarily
solve my problem.
I have on my worksheet a date entered by a user (sDateDue) that can be
current to many years old and I have a userform (sDate) that a user will
enter a date to compare with.

Basically I need to do this:
'If sDateDue is 1st of month and sDate is 2nd of month = No (Do not populate
"To Do List")
'If sDateDue is 1st of month and sDate is 31st of month = Yes (Populate "To
Do List")
'If sDateDue is 1st of month and sDate is 1st of month = Yes (Populate "To
Do List")

I am lost with out logic!
As always, your help is appreciated.
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007