Hi,
I need to create some datasets in Excel. For that purpose, I need to be able to specify data ranges and their date formats accordingly.
Sheet-1: Last 3 years
It should include a single column with every day info on each line with the start of the first year. For example, we're in 2023. So, the first line after header should start with the year 2020 and each line's (day) date format should be like 17/04/2022.
Sample:
01.01.2020
02.01.2020
03.01.2020
..
..
When I hit a formula or some other option, this lines should be arranged accordingly. If I select 1 year, then this should be listed for 1 year.
Sheet-3: Last 7 days
It should include a single column with every days and hours for the last 3 days on each line. For example, today is 5th, April. So, it should start with 29th, March the date format should be like 29/03/2023 01:00
Sample:
29/03/2023 00:00
29/03/2023 01:00
29/03/2023 02:00
..
..
30/03/2023 00:00
30.03/2023 01:00
..
I need to create these two sheets according to these info automatically based on the current date. Is there any formula to make this happen?
Thanks and Regards,
Bookmarks