RKS

Posts: n/a

difference two date

Anyone pl help me. How calculate difference between two date in the
year,month & date. I want to difference year, month & date ( all are
calculate).

Ex.
a1 = {01/12/1950}
b1={01/11/1960}

result we want b1-a1 = 9 year 1 month 10 days. (These format)

Pl Help me.

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
How do I create a schedule from a list of dates ?	Gavin Morris	Charts and Charting in Excel	2	October 28th 10 04:08 PM
search for latest date	Sue	Excel Worksheet Functions	2	August 2nd 05 11:09 PM
Date difference	Maxi	Excel Worksheet Functions	7	July 28th 05 01:38 PM
Date difference taking into account weekends.	annonymous	Excel Worksheet Functions	3	March 14th 05 05:35 PM
Difference of date	Atif	New Users to Excel	5	January 6th 05 10:53 PM

All times are GMT +1. The time now is 10:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us