Hi There,
am trying to put together a simple year-based calendar in excel.
each day will have it's own cell so that entries for things to be done can be put into that cell.....
easy, i know. here comes the tricky bit...
what i'd like to be able to do is have a section above the calendar which shows the events coming up in say, the next two weeks. this would be based upon 'todays' date and would somehow populate 14 free cells at the top with the info from the 14 cells following (and including as the first cell) todays date in the calendar.
afraid i have no idea how to do this! any help would be greatly appreciated!
thanks,
John
am trying to put together a simple year-based calendar in excel.
each day will have it's own cell so that entries for things to be done can be put into that cell.....
easy, i know. here comes the tricky bit...
what i'd like to be able to do is have a section above the calendar which shows the events coming up in say, the next two weeks. this would be based upon 'todays' date and would somehow populate 14 free cells at the top with the info from the 14 cells following (and including as the first cell) todays date in the calendar.
afraid i have no idea how to do this! any help would be greatly appreciated!
thanks,
John