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
pdvsaProject financeAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
try this

dateserial(year(date()),month(date())+2,0) + 15

should give you 6/15/2015
0
 
Saurabh Singh TeotiaCommented:
Use this way...

txtDateTo=DateSerial(Year([txtDateFrom]),Month([txtDateFrom])+2,0)+15

Open in new window


Saurabh...
0
 
pdvsaProject financeAuthor Commented:
Thank you
0
 
Gustav BrockCIOCommented:
Don't forget your date module. Then:

    txtDateFrom: DateAdd("d",15,DateNextMonthLast(Date()))

/gustav
0
 
pdvsaProject financeAuthor Commented:
Thank you GUSTAV.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.