txtMonth.Text = Month(Date)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"anu_manu" wrote in
message ...

Hey all
please let me know how can i calculate month of present date in VBA.
At present i can have the first date and present date by
txtStartDate = Format(Date - Day(Date) + 1, "dd/mm/yyyy")
txtEndDate = Format(Date, "dd/mm/yyyy").

but now i want to calculate MONTH of present date.

please help
thanks in advance


--
anu_manu
------------------------------------------------------------------------
anu_manu's Profile:
http://www.excelforum.com/member.php...o&userid=31510
View this thread: http://www.excelforum.com/showthread...hreadid=516246