In case you don't need historical data you can use this.. replacing
date should work fine in most cases...
On Oct 14, 11:04 am, Dilip Pandey wrote:
> Oh. . . . . that's awsome :)
>
> It is a good approach if u dont want to keep the history (previous month).
>
> Best Regards,
> DILIPandey
>
> On
Oh. . . . . that's awsome :)
It is a good approach if u dont want to keep the history (previous month).
Best Regards,
DILIPandey
On 10/13/10, renuka chari wrote:
> HI DILIP THANKS
> FINALLY I GOT A ANSWER WITH OUT USING FORMULA SELET ENTIRE COL AND FIND
> (CTRL+F) ENTER 10/11/2010 & REPLACE 11
HI DILIP THANKS
FINALLY I GOT A ANSWER WITH OUT USING FORMULA SELET ENTIRE COL AND FIND
(CTRL+F) ENTER 10/11/2010 & REPLACE 11/11/2010 THEN FINALLY I GOT THAT.
On 12 October 2010 15:23, Dilip Pandey wrote:
> Hi Renuka,
>
> Try using following formula.
>
> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
Thanks dilip thanks alot its working good, but there is no option to change
month with out using formula
On 12 October 2010 15:23, Dilip Pandey wrote:
> Hi Renuka,
>
> Try using following formula.
>
> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"mm/dd/")&"
> "&TEXT(TIME(HOUR(A1),MINUTE(A1),SECO
Thanks Anand.. :)
Best Regards,
DILIPandey
On Wed, Oct 13, 2010 at 12:15 PM, anandydr wrote:
> Hi,
>
> The formula by Dilip works perfectly on the sample data provided,
> can't think of a better solution.
>
> Warm regards,
> Anand Kumar
>
> On Oct 12, 2:53 pm, Dilip Pandey wrote:
> > Hi Renuka
Hi,
The formula by Dilip works perfectly on the sample data provided,
can't think of a better solution.
Warm regards,
Anand Kumar
On Oct 12, 2:53 pm, Dilip Pandey wrote:
> Hi Renuka,
>
> Try using following formula.
>
> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"mm/dd/")&"
> "&TEXT(TIME(HOUR
Hi Renuka,
Try using following formula.
=TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"mm/dd/")&"
"&TEXT(TIME(HOUR(A1),MINUTE(A1),SECOND(A1)),"hh:mm am/pm")
Let me know if this solves your problem :)
Best Regards,
DILIPandey
On 10/11/10, renuka chari wrote:
> hi excel experts i have a small p
hari
> To: MS EXCEL AND VBA MACROS
> Sent: Mon, October 11, 2010 11:20:37 AM
> Subject: $$Excel-Macros$$ good evening to all experts
>
> hi excel experts i have a small problem
>
> MY DATE AND TIME FORMAT IS "mm/dd/ hh:mm
hi excel experts i have a small problem
MY DATE AND TIME FORMAT IS "mm/dd/ hh:mm am/pm"
I WANT
TO CHANGE COL: A CHANGED IN TO COL:A"
=
col:a col:a
=
10/11/2010 18:37
