filmov
tv
Calculate Quarter start date and end date from current date using Excel?
Показать описание
Excel formula to calculate quarter start date and end date is the following
Start Date of the quarter
=EOMONTH(A2,-MOD(MONTH(A2)-1,3)-1)+1
End date of the quarter
=EOMONTH(A2,-MOD(MONTH(A2)-1,3)+2)
Works in Excel 2007/2010/2013/2016
Start Date of the quarter
=EOMONTH(A2,-MOD(MONTH(A2)-1,3)-1)+1
End date of the quarter
=EOMONTH(A2,-MOD(MONTH(A2)-1,3)+2)
Works in Excel 2007/2010/2013/2016
0:02:12
0:04:53
0:01:09
0:00:43
0:01:01
0:05:39
0:05:31
0:02:37
0:07:58
0:02:07
0:05:21
0:04:05
0:01:00
0:05:03
0:06:52
0:03:18
0:02:41
0:04:20
0:00:58
0:01:00
0:03:09
0:01:19
0:00:30
0:11:40