Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Windows XP Home SP2 and Excel 2003 SP1
I require a macro to check that todays date falls on or between two dates, one in current month and second in next month and then enter the 5th day of first month in a cell i.e. If Today() is 05-09-04 enter 5-09-04 in cell B2 If Today() is 04-10-04 enter 5-09-04 in cell B2 or another way to explain would be; If todays date falls on or between the 5th of current month and the 4th of next month enter the 5th of first month. I hope I have explained my question clearly enough for all to understand. I'll be attaching macro to a screen button to return cell B2 back to normal. TIA BobC. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF - Date falls between two dates, place here | Excel Worksheet Functions | |||
finding if a date falls between two dates | Excel Discussion (Misc queries) | |||
finding if a date falls between two dates | Excel Discussion (Misc queries) | |||
Pulling Data that falls within a specific date range? | Excel Worksheet Functions | |||
How to find if a date falls between 2 dates | Excel Worksheet Functions |