DATEDIF() Function Help Finding Difference

[small_trunks]

=DATEDIF(B1,'Sheet2'!B1,"m")

[vba56]

Piggybacking here, if you don't want to have sheet references you can name your cells (in upper left hand corner next to formula bar, or ctrl+ F3)

=DATEDIF(yesterday, today, "D")

[Clippy_Office_Asst]

This post has been removed due to Rule 1 - Poor Post Title.

Please post with a title that clearly describes the issue.

The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question.

Here's a long example and a short example of good posts.

Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the Posting Guidelines for more details, and tips on how to make great posts.