1

I have a column that holds the month number(1....60) I want in another column to indicate what the number "1" is (in this case January 2023) I need a formula to look at a column, if the number is "1" return the date Jan 2023 to another column, same row. to help I have two columns listed with the reference between number and date...i.e month 1=Jan 2023, month 2=February 2023...and on for 5 years. In summary Row 23 column F equals "1" I want the physical month and year in A 23 At the bottom of the sheet I have columns like this: date number jan 2023 1 Feb 2023 2 ...and so on... I need help. Mike

1 Answer 1

0

sequence

Given that "jan 2023" is not a date (1 jan 2023 is a date) and assuming that cell A2 contains that value as the starting date, you can get the desired result by entering this formula in cell B2:

=index(date(year(A2),month(A2)+sequence(60)-1,1))

note that column B must be formatted as a date and that there is no need for any other helper columns

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.