pdvsa
asked on
Formula for end of next month plus 15 days
Experts, I have a filter form with unbound text boxes txtDateFrom and txtDateTo.
I am looking for a formula that will return in the txtDateFrom: the end of next month plus 15 days.
ie todays date is 4/9/15: return would be: 5/31+15 days
thank you
I am looking for a formula that will return in the txtDateFrom: the end of next month plus 15 days.
ie todays date is 4/9/15: return would be: 5/31+15 days
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
Don't forget your date module. Then:
txtDateFrom: DateAdd("d",15,DateNextMon thLast(Dat e()))
/gustav
txtDateFrom: DateAdd("d",15,DateNextMon
/gustav
ASKER
Thank you GUSTAV.
Open in new window
Saurabh...