Thanks for your help.
Every solution is working and fine.
Thanks once again friends
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Ple
$Excel-Macros$$ Calculate years and months between today daye and
given date
Hi,
use this =DATEDIF(A2,TODAY(),"y")&" Years "& "and
"&DATEDIF(A2,TODAY(),"ym")&" Months"
--
Best Regards,
Ms Excel User
On Mon, N
You've asked for the FORMULA,
That implies that you don't want to use VBA, but wish to use Excel formulas.
Let's say that the date you're checking is in A2,
The simple answer is to subtract this year "Year(Today())"
>From the year of the of the date in A2 "Year(A2)"
giving:
YEAR(TODAY())-YEAR(A2)
You can use the following formula
=YEAR(D4)-YEAR(D3)&" Years"&" "&MONTH(D4)-MONTH(D3)&" Months"
Aamir Shahzad
On Mon, Nov 5, 2012 at 4:51 PM, Kuldeep Singh wrote:
>
> Hi,
>
> You can use *DATEDIF()* formula.
>
> Regards,
> Kuldeep Singh
>
>
> On Mon, Nov 5, 2012 at 5:11 PM, excel lerner wrote:
Hi,
You can use *DATEDIF()* formula.
Regards,
Kuldeep Singh
On Mon, Nov 5, 2012 at 5:11 PM, excel lerner wrote:
> Hello sir
>
> Can you please explain how to get completd years ,Months bet ween
> todays date and pevius year date.example
>
> 01/04/1954
> 05/11/2012
>
> please tell me the formul
