how do i link dates between worksheets?
 

i'm trying to set up a weekly workbook. each day of the week has it's own
tab. trying to get the dates to correspond to each other. can i set up a
formula that does this? can excel reset the dates for each week? if i had 4
different workbooks, representing 4 weeks, do i have to manually enter the
date for each day? don't know much about this stuff.