Register now or log in to join your professional community.
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 |
=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)
Try this =DAY(EOMONTH(A1,0))
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
Eomonth(A1;0)-A1
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
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
