How to change month format to a specific date range?

Please look at revised sheet.

Thanks again for all your ideas. However, I'm still having no luck with the suggestions.

I've since tried IF function, but not able to think of a formula that looks at whole pay date range.
I've attached doc which further explains this.


ExcelQuestion.xlsx















I am looking to set the months up within the period of my pay days, so to properly reflect my spending within that period.
I get paid on 26th of each a month, so I would like to set it so that each month starts from 26th.

e.g.

July 2022. - Pay Period: 26.07.22 - 25.08.22

Aug 2022 - Pay Period: 26.08.22 - 25.09.22

Sep 2022 - Pay Period: 26.09.22 - 25.10.22

so on and so forth...

However, in the months which the 26th falls on a weekend, the pay date changes to the nearest preceding week-day.
So following from the example above the next pay period would be:

Oct 2022 - Pay Period: 26.10.22 - 24.11.22. not... 26.10.22 - 25.11.22
...as Nov 26th 2022 falls on a weekend, so therefore pay date is the nearest preceding week-day, which is 25.11.22.

So the Pay period after that would be .... Nov 2022 - Pay Period: 25.11.22 - 25.12.22


Hope this make sense. If not please ask for clarification.


Question:
How can I set this up in excel?

I've used M01 etc but would ideally like B:B to return a Month text (i.e., September) based on whether A:A falls between the specific start and end dates (columns K & L).


Excelforumhelp.xlsx

I am relatively new to excel so my know-how is very limited. All solutions welcome.


Thanks in advance

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Try

in B2

=TEXT(A2,"mmmm")

in K2

Formula:

Please Login or Register  to view this content.

Hi,
I think that version 16.34 is for MAC and I don't know and I don't know which Excel functions are available for this version.
So, I tried with what I have.
In B2:

Formula:

Please Login or Register  to view this content.

In J2
The same formula

Formula:

Please Login or Register  to view this content.

In K2(for start date of period):

Formula:

Please Login or Register  to view this content.

In L2:

Formula:

Please Login or Register  to view this content.

In B13:

Formula:

Please Login or Register  to view this content.

In C16

Formula:

Please Login or Register  to view this content.

In F18:

Formula:

Please Login or Register  to view this content.

Are you using a Romanian version of Excel?

May be you should try, because month = lună:

Formula:

Please Login or Register  to view this content.

OR

If you want English month names in a Romanian version of Excel, please try

Formula:

Please Login or Register  to view this content.

The letter l looks like a digit 1. The formula uses letters l (not digits 1).

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...range.1218803/)

You want in Column B to get the Month of pay period?

In B2 insert a formula:

Formula:

Please Login or Register  to view this content.