View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wendy Wendy is offline
external usenet poster
 
Posts: 99
Default Macro that will detemine date and then check off a box

I have a cell titled Commit Date that you will fill in a date. At the top of
the spreadhseet I have the current date. I need a macro that takes the
current date plus 7 days and checks a box off (Lists it as a Focus Item) if
the commit date falls within that date range.

I'm new at macros and am completley lost on this one. Any help would be
greatly appreciated!

Thank You, Wendy