Re: calculating month of present date
- From: anu_manu <anu_manu.23qwum_1140804603.3698@xxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 24 Feb 2006 12:09:17 -0600
i format it as this
Format(month(date),"mm/dd/yyyy")
isn't it right?
Actually,my problem is this..
Currently the Start Date defaults to the first day of the current
month.
The request is to default the start date to the first day of the
quarter
(e.g. 01.01, 04.01,07.01,10.01... +year).
If the current month is between 1 and 3, default is 01.01.+current
year
If the current month is between 4 and 6, default is 04.01.+current
year
Please kindly guide.
--
anu_manu
------------------------------------------------------------------------
anu_manu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31510
View this thread: http://www.excelforum.com/showthread.php?threadid=516246
.
- Follow-Ups:
- Re: calculating month of present date
- From: Bob Phillips
- Re: calculating month of present date
- References:
- calculating month of present date
- From: anu_manu
- Re: calculating month of present date
- From: Bob Phillips
- Re: calculating month of present date
- From: anu_manu
- calculating month of present date
- Prev by Date: Re: Associated Numerical Values
- Next by Date: Re: Keep formatting with lookup table
- Previous by thread: Re: calculating month of present date
- Next by thread: Re: calculating month of present date
- Index(es):
Relevant Pages
|