Shortest Formula for returning Number of Days in the month of "given date"

Question

Column "A" = Given Date (for example>2-Feb-2014)
Column "B" =  No. of days required in the month of given date (for example=28) 

	Date	=	No. of days in that month	
  |1-Apr-13	=30	  |
  |4-Jul-14	=31	  |
  |9-Jan-01	=31	  |
  |4-Aug-12	=31	  |
  |2-Feb-14	=28	  |
  |9-Dec-14	=31	  |
  |8-Aug-11	=31	  |
  |4-Feb-12	=29	  |
  |1-Apr-13	=30	  |

Hussain Marzooq · Answer

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

Ashfaque Deshmukh · Answer

Try this =DAY(EOMONTH(A1,0))

Kashif Sherazi · Answer

Dear Friend

Use following formula if your date is in Cell E6

=(EOMONTH(E7,0))-(EOMONTH(E7,-1))

Please check and give your feed back

My e-mail is

Regards

Kashif Manzoor Sherazi

Omar Siddique · Answer

Eomonth(A1;0)-A1

Howida Elrasheed Awad Elkareem Mohammed · Answer

use this formula

=DAY(DATE(YEAR(A2),MONTH(A2)+1,))

Also i found this channel on youtube very usefeul for the ultimate usage of excel,

https://www.youtube.com/user/ExcelIsFun

good luck

FITAH MOHAMED · Answer

simply formula is

= Eomonth(A1;0)-A1

because eomonth determine the last day in the month serial- the date in cell a =

days required in the month of given date

note :

better formate column B as number

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

Shortest Formula for returning Number of Days in the month of "given date"

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة