Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a home budget data list with col B containing past and future dates (dd/mm/yy) for income and expenditure / bills that appear in adjacent cells. These dates for expenses/expenditure are entered randomly, though sorted on date often. I'm struggling to find code to attach to a button that will go down the list (B4:B2000) so today's date is displayed, or if today's date isn't entered, the closest date to today. Entries will always appear at least every fortnight (pay day). Any help would be appreciated. Regards, Ricky |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
I need today's date returned as date format in formula | Excel Discussion (Misc queries) | |||
Count number of cells with date <today's date | New Users to Excel | |||
count the number of cells with a date <= today's date | New Users to Excel |