Excel Forum

Awesome.brother,how we can do conditional formatting?

Regards,

Hi Dear

Could i ask you one thing i have such data by respectively column A thru C

Date Dr Cr
7/4/16 799.35
18/4/16 189.99
22/4/16 874.83
27/4/16 120
27/4/16 189.99
5/5/16 799.35

I want to match the same amount for Debit nd Credit amount.

Regards,

Thank,i got it now

Could you give some explaination about this formula?if kindly could you upload file relating these?

Ok,thanks

I test it this formula only works for month end if i change to like 01/01/2016 or 01/02/2016...it is not woorking

Thanks bro i shall try and revert

Before and after this specified date?

It is still not working

Can this output is possible in one cell like 128 year 8 month & 7 days?

Hi any one knows how to calculate difference between 2 dates prior to 1900 for eg difference between - 15/10/1888 to 22/06/2016

Could u give me mai id i shall forward it to and kindly upload in this group?

I have not seen file to download.