Auto populate dates from 26th of current month to 25th of next month

T

Tija

New Member
Joined
Apr 19, 2022
Messages
17
Office Version
  1. 365
Platform
  1. Windows
The employee salary period starts 26th of every month and ends 25th of the next month. The task is to enter month and year manually in cell address B1 to populate the dates in cell range C7:AG7 using a formula.
 

Attachments

  • Date auto populate.png
    Date auto populate.png
    103.1 KB · Views: 13

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
If the date in B1 is a real date, how about
Excel Formula: 
=LET(s,DATE(YEAR(B1),MONTH(B1),26),SEQUENCE(,DATE(YEAR(B1),MONTH(B1)+1,26)-s,s))
 
Upvote 0
Solution
Awesome!!! Thank you Fluff. I would love to understand the logic and explanation behind your formula. I tried differently with helper fields.
 

Attachments

  • Date auto populate 1.png
    Date auto populate 1.png
    184.3 KB · Views: 8
Upvote 0
Glad to help & thanks for the feedback.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
Make Month start on 26th and end on 25th of the next month
Replies
4
Views
182
Peter_SSs
Peter_SSs
K
  • Solved
Prorating Salary based on hire date and Term date - by month
Replies
4
Views
171
KH Consulting
K
Z
  • Question
Dynamic Working and Week days remaining until end of month from a specific date in the month
Replies
3
Views
168
Peter_SSs
Peter_SSs
A
  • Question
Creating a Calendar for a Month with tasks
Replies
0
Views
158
anuradhagrewal
A
C
  • Solved
List of months between and including 2 dates
Replies
4
Views
99
awoohaw
awoohaw

Forum statistics

Threads
1,215,494
Messages
6,125,139
Members
449,207
Latest member
VictorSiwiide

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top