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
Bookmarks