start date and end date of the month in broad cast calendar

pavan5

Board Regular
Joined
Jun 13, 2017
Messages
56
Can someone help me in finding out a formula for figuring out first day and last of the month for a broad cast calendar. Example for Jun 1 2017, the start of month should be May 26th 2017 since Jun 1st falls on a Thursday end date would be normal Jun 30 2017, like wise for Jul 2017, the start date of the month would be June 29 2017 for Aug 2017 it would be July 31 2017 ...The first day(1) of any month should be on Monday.

Any help would be greatly appreciated!
 
That can be done, and there's probably already a thread on it.
Try using the search tool for October quarter

Or make a new thread with the new question.
 
Upvote 0

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,216,211
Messages
6,129,528
Members
449,515
Latest member
lukaderanged

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