LinkBack URL
About LinkBacks
Hello,
I'm New in Excel.
what I want is this example.
"A1" is Data "25/01/2012" in "B1" is Date "25/03/2012" how to calculate in "C1" = Rezultat "3" (3 Month)
Is this possible to calculate how many months have passed, in this Examble is 3
Thank You
Hello,
I'm New in Excel.
what I want is this example.
"A1" is Data "25/01/2012" in "B1" is Date "25/03/2012" how to calculate in "C1" = Rezultat "3" (3 Month)
Is this possible to calculate how many months have passed, in this Examble is 3
Thank You
Last edited by johan12; 03-25-2012 at 03:34 PM.
Why is it 3? By my reckoning March 25th is exactly 2 months after January 25th, this formula will give you 2
=DATEDIF(A1,B1,"m")
Audere est facere
It is works prefect. Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks