cancel
Showing results for 
Search instead for 
Did you mean: 

From given date how many days happen in a month

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

sateesh_kumar1
Active Contributor
0 Kudos

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.

Answers (0)