Related:
- Date Am and PM but need the date to change
- Change hotmail password - How-To - Hotmail
- How to change date format in excel to dd/mm/yyyy - How-To - Excel
- How to change primary email on facebook - How-To - Facebook
- How to change number of bestfriends on snapchat with new update 2019 - How-To - Instant Messaging
- How to change language in hotstar in lg tv - How-To - Hardware
2 replies
TrowaD
- Posts
- 2693
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- January 18, 2021
Hi JeepTruck,
I think you are confused with the terminology of workbooks and worksheets. Workbooks are the Excel files and worksheets are the tabs within an Excel file.
So what I think you are trying to do is put 1 date in cell A1 of the first sheet and the other 11 automatically pick that date and changes the month, so that all 12 sheets represent a month of the year.
If I'm right in my assumption, then try this:
Fill out the date on your first sheet, then use the following formula on sheet 2:
=DAY(Sheet1!A1) & "-" & MONTH(Sheet1!A1)+1 & "-" & YEAR(Sheet1!A1)
Then for sheet 3 you can either change the sheet reference Sheet1! to Sheet2!
OR
change +1 to +2 in the middle of the formula.
Best regards,
Trowa
I think you are confused with the terminology of workbooks and worksheets. Workbooks are the Excel files and worksheets are the tabs within an Excel file.
So what I think you are trying to do is put 1 date in cell A1 of the first sheet and the other 11 automatically pick that date and changes the month, so that all 12 sheets represent a month of the year.
If I'm right in my assumption, then try this:
Fill out the date on your first sheet, then use the following formula on sheet 2:
=DAY(Sheet1!A1) & "-" & MONTH(Sheet1!A1)+1 & "-" & YEAR(Sheet1!A1)
Then for sheet 3 you can either change the sheet reference Sheet1! to Sheet2!
OR
change +1 to +2 in the middle of the formula.
Best regards,
Trowa
kurhanskakr
- Posts
- 4
- Registration date
- Monday December 23, 2019
- Status
- Member
- Last seen
- January 14, 2020
Excel contains the feature of any data auto-filling. To perform that, you need to write the first value in the right format(f.e. 01.01.2020) after that you should pull the small square(as at the screen) down, left, up, or right. If you'll pull from 01.01.2020 to 5 positions right, you'll get the automated filled data in the selected area from 01.01.2020 to 06.01.2020. But if you would like to make auto-filling of data more specific, you can code custom macros using VBA(is inbuilt).
Subscribe To Our Newsletter!
