Share via

Need Help Generating Formula

Anonymous
2024-08-24T14:20:11.86+00:00

Hello,

I need help generating a formula that reads: If the month number in PurchaseDate cell matches a value in MonthNumber column of Table1, then use MonthNumber in Table1 to return MonthName in the Month cell.

I then need the formula to fill in all of the rows.

I tried on my own and failed miserably lol

Please tell me if I'm on the right track??

User's imageUser's image

Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Barry Schwarz 3,746 Reputation points
    2024-08-24T16:03:49.4433333+00:00

    You don't need the tables. Excel has the data built into the TEXT function. In H2 enter

    =TEXT(G2,"mmmm")

    and copy it into as many cells as needed.

    The numeric day and year can be obtained with the DAY and YEAR functions. If you need weekday names, use the "dddd" format in the TEXT function.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.