Use formulas to get the beginning or final day of the month.
Use formulas to get the beginning or last working day of the month.
In a blank cell, type =DATE(YEAR(B1),MONTH(B1),1) B1 holds the date you wish to use), as seen in the screenshot:
The Nth occurrence is N-0 weeks after the first. The formula increases the month's start date by (N-0) * 7 days.
The day of week is abbreviated "dow" in the general form of the formula at the top of the page. This is a number that can be altered between 1 (Sunday) and 7 (Saturday) to get a new day of the week. Set dow to 5 to receive the last Thursday of the month, for example.
In Cell A1, type a date, and in Cell B1, type =EDATE(4/15/2013,-5). We're entering a date surrounded in quote marks to specify the value of the start date. For the same effect, you can simply refer to a cell that holds a date value or use the formula =EDATE(A1,-5)
Learner's Ratings
3.7
Overall Rating
49%
20%
5%
7%
19%
Reviews
P
Pratik Meshram
5
where is assignment PDF
Gourav Parmar
5
Hey Provide me the Practice File
G
Gitesh Saini
5
This aap very helpful for human
R
Rishu Baghel
4
sir, can you provide us some table for practice?
S
shams faishal
4
please provide your excel file so it will be easy to learn fast
P
Pintu Kumar
5
improve video quality, because its excel file and the pixel is not good.
J
Juboraj Juboraj
4
Explain details & easy to understand.
M
MD Ayaz Rain
4
powerBI use a data Analysis course in hindi
O
Omkar Jitendra Shinde
4
It is great course
V
Vaibhav Magar
5
I would suggest Absolute reference in 13:30 for the calculation of percentage
Share a personalized message with your friends.