Return months based on year

**Abdur_rahman** · 03-21-2020, 02:18 AM

Hello again.

I am looking for a formula where a user enter a year in Cell A1 and all the 12 months will be return beside.

For Example:
A1 = 2019 then B1 = 01-01-2019, C1 = 01-02-2019, D1 = 01-03-2019, etc...

**protonLeah** · 03-21-2020, 02:45 AM

Use the date function with a1 for the year and the column number for the month...

**Mrrrr** · 03-21-2020, 04:00 AM

What protonLeah probably means is put this in B1 and drag right to M1:
=DATE($A1;COLUMN()-1;1)

**Abdur_rahman** · 03-21-2020, 04:20 AM

thanks for your help.

Return months based on year

LinkBack

Thread Tools

Rate This Thread

Display

Return months based on year

Re: Return months based on year

Re: Return months based on year

Re: Return months based on year

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Generate Months and Year Table based on Cell Drop down data

Year based on months and highest date in source data

project figures for rest of this year based on last 18 months?

[SOLVED] VBA Insert Current Month, Year and subsequent months/year for 15 months

Months in a year based on number of days

[SOLVED] Return 12 Months from Year End Date

Possible to pull info based on months only and not year?

Bookmarks

Bookmarks

Posting Permissions