use datediff la brother.
gile panjang kod, tapi tak betul muahaha.
Microsoft Excel formulae....... How to do this?
|
|
 May 8 2008, 03:07 PM
Return to original view | Post
#1
|
 
Senior Member
2,280 posts Joined: Jun 2006 
|
|
Quote|
|
May 8 2008, 03:20 PM
Return to original view | Post
#2
|
|
Senior Member
2,280 posts Joined: Jun 2006
|
The syntax for DATEDIF is as follows:
CODE =DATEDIF(Date1, Date2, Interval) Where: Date1 is the first date, Date2 is the second date, Interval is the interval type to return. Example - different of date in month CODE =DATEDIF(Date1,Date2,"m") QUOTE Code for Interval This post has been edited by dopodplaya: May 8 2008, 03:21 PMm - Months Complete calendar months between the dates. d - Days Number of days between the dates. y - Years Complete calendar years between the dates. ym - Months Excluding Years Complete calendar months between the dates as if they were of the same year. yd - Days Excluding Years Complete calendar days between the dates as if they were of the same year. md - Days Excluding Years And Months Complete calendar days between the dates as if they were of the same month and same year. |
| Change to: |  0.0159sec
 0.78
 6 queries
 GZIP Disabled
Time is now: 12th December 2025 - 12:30 AM |
All Rights Reserved © 2002- 2025 Vijandren Ramadass (~unite against racism~)
Powered by Invision Power Board © 2025 IPS, Inc.