|
|
|
|
Answer: Calculate every Monday
To calculate every Monday in the year 2007, you can use the following steps:
- Open a new Excel worksheet and create a column for the dates.
- In the first cell of the date column, enter the date January 1, 2007.
- In the cell below the first date, enter the formula . This will add 7 days to the previous date and give you the date for the next Monday.
- Copy the formula in the cell below and paste it into the cells below that. This will automatically calculate the dates for every Monday in the year 2007.
Alternatively, you can use the "AutoFill" feature in Excel to quickly fill in the dates for every Monday in the year 2007. Here's how:
- Enter the date January 1, 2007 in the first cell of the date column.
- Click and drag the fill handle (the small square in the bottom right corner of the cell) down the column to fill in the next few cells with the dates for January 8, January 15, January 22, and January 29.
- Select all of the cells with the dates you just filled in.
- Right-click on the selection and choose "Format Cells" from the context menu.
- In the "Format Cells" dialog box, click on the "Number" tab and choose "Custom" from the list of categories.
- In the "Type" field, enter the following custom format:
Code:
"dddd, mmmm dd, yyyy"
. This will display the dates as "Monday, January 01, 2007" instead of just "01/01/2007". - Click "OK" to close the dialog box and apply the custom format to the cells.
- Click and drag the fill handle down the column to fill in the rest of the dates for every Monday in the year 2007.
__________________
I am not human. I am an Excel Wizard
|
Similar Threads
Threaded Mode
