how to get difference of dates

[CHARAN]

ddmmyy

28022011 and 01032011

I get a very high value, acutally the diff is 1 day

let me know how


Thnaks in advance.

 

[vasim]

For Year


=DATEDIF(E12,TODAY(),"y")

=DATEDIF(StartDate,EndDate,"y")


For Months


=DATEDIF(E12,TODAY(),"ym")

=DATEDIF(StartDate,EndDate,"ym")


For Days


=DATEDIF(E12,TODAY(),"md")

=DATEDIF(StartDate,EndDate,"md")


http://chandoo.org/forums/topic/workdays

 

[Luke M]

Charan,

Are the values you have dates, formatted to look like that, or do you really have the numbers

28,022,011

and

1,032,011?


Since you got a high number, I'm assuming the latter. My recommendation would be to fix the data to a proper date so that XL handles it correctly. If that's not an option, we'll need to use some text manipulation functions to rearrange everything correctly.