My timesheet mission is almost complete. One question at a time. My next question is this: attached is the Timesheet (working copy), in cell C3 (yellow fill)i have a dropdown menu with two week time periods (i.e. 2 Mar-15 Mar). In the cells with red fill i have the actual day by day time periods. What im trying to do is when i select the time period from cell C3 (yellow fill drop down menu), for it to the auto populat the daily cells (red fill) with correct dates.
*The attached spreadsheet has the current format: I select date from C3 (dropdown menu), then i manually type in the first date in cell F4, then the rest of the cells auto populate by using the =F4+1, etc.
Thank you...
Bookmarks