How to Count Ageing

Ashu K

unread,

Oct 25, 2015, 7:17:23 AM10/25/15

to Excel VBA Lab

Dear Seniors,

I want to Count Difference between Dates.

Example :

Date 1	Date 2	Ageing
25/10/2015	25/10/2015	0
22/10/2015	25/10/2015	3

Please suggest the easy function.

Thanks & Regards

Ashu Kenith

Ashu K

unread,

Oct 26, 2015, 11:44:27 AM10/26/15

to Excel VBA Lab

Dear Seniors,

Please help.

Thanks & Regards

Ashu Kenith

Amandeep kaur

unread,

Oct 26, 2015, 1:21:26 PM10/26/15

to Excel VBA Lab

Hi,

Try this formula:

=Datedif(start_date,end_date,"interval")

Example:
=Datedif(E1,E2,"D")

Regards
Amandeep Kaur

Amandeep kaur

unread,

Oct 26, 2015, 1:26:12 PM10/26/15

to Excel VBA Lab

Just for your reference here we have used "D" for days count, you can also try this formula with "M" to count months and "Y" to calculate years between two days.

Regards
Amandeep Kaur
Excel lover

Ashu K

unread,

Oct 26, 2015, 1:35:07 PM10/26/15

to Excel VBA Lab

Dear Amandeep,

Thanks for your help. This formula is not working for me. Please check and advise.

mtanveerkhan

unread,

Oct 27, 2015, 6:48:43 AM10/27/15

to Excel VBA Lab

Yes the Formulae is working.

Ashu K

unread,

Oct 27, 2015, 11:13:15 AM10/27/15

to Excel VBA Lab

Not working for me. Sheet is attached for your reference.

Kindly suggest.

Ageing.xlsx

Ashu K

unread,

Oct 30, 2015, 10:36:42 PM10/30/15

to Excel VBA Lab

Dear Seniors,

Please suggest any other solution.

Ashish Bhalara

unread,

Oct 30, 2015, 10:51:47 PM10/30/15

to Excel VBA Lab

Hi Ashu K,

The Ageing means difference between two date which you get by subtracting previous date from last date because date is actual numeric value. See attached file for reference.

Regards

Ashish Bhalara

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/c25d8a4e-e956-4696-8739-6a8d3a89128e%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Ageing.xlsx

Ashu K

unread,

Oct 31, 2015, 12:12:59 PM10/31/15

to Excel VBA Lab

Dear Ashish Bhalara Sir,

Not working...!

Image is attached for your reference. kindly help.

Thanks & Regards

Ashish Bhalara

im.jpg

Ashish Bhalara

unread,

Oct 31, 2015, 11:00:13 PM10/31/15

to Excel VBA Lab

Hi Ashu K,

I think cell format is not looking Date, change the format of 'Date' or go to cell and press F2+Enter to change format of Date.

Regards

Ashish Bhalara

--

www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.

To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/06f701fe-3711-4178-afc2-99a2425ee78b%40googlegroups.com.

Ashu K

unread,

Nov 1, 2015, 10:52:07 AM11/1/15

to Excel VBA Lab

Dear Ashish Bhalara Sir,

Thanks,, but it's not working for me :(

Any other Option..!

Reply all

Reply to author

Forward