Skip to Content
avatar image
Former Member

From given date how many days happen in a month

Hi Experts,

I have a small query in my report  i.e From given date how many days happen in a month

date= current date

26/12=26/12  means 25 days happen.

12/12=12/12 means from 1st of month to today 12 days happen

i need a formula for this i tried it but unable to crack it so please help me

rest how many days i need to calculate

Thanks & regards,

vinay.G

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 26, 2014 at 11:54 AM

    Hi Vinay ,

    use

    =DayNumberOfMonth(CurrentDate())

    or

    if you have any date prompt

    =DayNumberOfMonth(todate(userresponse("Select Date");"INPUT_DATE_TIME")

    or

    you can use =daysbetween() function also.

    Add comment
    10|10000 characters needed characters exceeded