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
|