Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
Toggle a range of Julian dates to Gregorian Dates and Back | Excel Programming | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel |