on 12-26-2014 10:42 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.