Ask Experts Questions for FREE Help !
Ask
    santoshdream's Avatar
    santoshdream Posts: 11, Reputation: 1
    New Member
    		  
    #1

    Feb 2, 2010, 01:42 AM
    Datedif function for mm/dd/yyyy
    =DATEDIF(A1,TODAY(), "y").

    if Cell A1 = 08/15/1947 (MM/DD/YY Format)
    I want to calculate the exact month. Above function is not working. Please help.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Feb 2, 2010, 10:14 AM

    The formula you've shown is set to show YEAR differences, that's what the "y" flag accomplished.

    If you want the number of months between the two dates, change that to "m".

    If this still isn't what you want, provide a more complete example problem.

    Date1 in cell A1
    Today's date is??
    Expected result would be: _________ (and why)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Function e^x [ 2 Answers ]

dear sir , I'm asking about the table of variation for function ( e^2x - 3.e^x +2) / ( e^2x + 3.e^x - 4 ) and I need the shape of graph representing this function

The result of increasing and decreasing function on the composite function [ 6 Answers ]

I was asked to prove the result of increasing and decreasing function on the composite function... prove that: 1- if f(X) inc & g(X) inc, foG inc 2-if F(X) inc & G(X) dec, foG dec 3- if F(X) dec & G(X) inc, fog dec 4- if f(X) dec & G(X) dec, fog inc please help me in that

Function Or Not? [ 1 Answers ]

Tell whether or not the pairing is a function Input Output 9 0 8 2 7 4 7 6 I think it is I'm just not sure it's the 2 sevens that Are really bothering me if someone can help id...

TV Out Function On [ 0 Answers ]

I've got a DVD drive and the PowerDVD 5.0 player and every time I try to watch a newer DVD, I get the error message "TV out function error", I look at the details and it says I can't play copyright protected DVD's with the TVout function enabled. The weird thing is, ALL my graphics adapters just...

View more questions Search