Finding the First and Last Days of the Week and Month - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Thursday, January 23, 2020

Finding the First and Last Days of the Week and Month

Finding the First and Last Days of the Week and Month
Here are formulas to return various dates of first and last days of a given month.
First day’s date of that month: =DATE(YEAR(B1),MONTH(B1),1)
Last day’s date of that month: =DATE(YEAR(B1),MONTH(B1)+1,0)
First Monday date of that month:
=DATE(YEAR(B1),MONTH(B1),8)-WEEKDAY(DATE(YEAR(B1),MONTH(B1),6))
Last Friday date of that month:
=DATE(YEAR(B1),MONTH(B1)+1,1)-WEEKDAY(DATE(YEAR(B1),MONTH(B1)+1,1)-6)
First day of the month, 3 months later: =DATE(YEAR(B1),MONTH(B1)+3,1)
Last day of the month, 3 months later: =DATE(YEAR(B1),MONTH(B1)+4,0)
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

No comments:

Post a Comment