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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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
186
Peter_SSs
Peter_SSs
K
  • Solved
Prorating Salary based on hire date and Term date - by month
Replies
4
Views
224
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
199
Peter_SSs
Peter_SSs
A
  • Question
Creating a Calendar for a Month with tasks
Replies
0
Views
174
anuradhagrewal
A
C
  • Solved
List of months between and including 2 dates
Replies
4
Views
110
awoohaw
awoohaw

Forum statistics

Threads
1,216,100
Messages
6,128,827
Members
449,470
Latest member
Subhash Chand

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