Posted to microsoft.public.excel.programming

Ranjith Kurian[_2_] Ranjith Kurian[_2_] is offline

external usenet poster

Posts: 48

Date Variable

Hi

I have one problem with the below code, it showing me the march 9th date,
how will i change it to 1st of every month, so that next month when i run
this it should show me 1st of April.

curmt = Format(Date, "mmm-yy")
curmth = CDbl(CDate(curmt))
MsgBox curmth

Answer is 39881, the required answer is 39873

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Variable	Ranjith Kurian[_2_]	Excel Programming	6	March 26th 09 02:52 PM
variable for Date	Ranjit kurian	Excel Programming	10	January 23rd 09 04:54 PM
add 1 day to date variable	DaveMZ[_2_]	Excel Programming	1	April 10th 07 05:50 PM
calc constant date from variable date & return with ability to rn.	SusieQ'sQuest	Excel Worksheet Functions	1	November 9th 04 08:51 PM
Compare Date in Cell VS a Variable Date to Hide Row	JimI	Excel Programming	3	October 10th 04 04:26 PM

All times are GMT +1. The time now is 06:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us