Post: #1
Calculate number of years, months and days between 2 given dates

In B1 Enter a date above: 01.01.1900
Enter any date in D1

Place the following formula in any cell and press enter.

Formula is too big if I write here it goes beyond page width. It can not be given break. Therefore formula is attached.

[Image: find+years+months+dates+between+2+dates.png]


.txt  excel formula.txt (Size: 410 bytes / Downloads: 170)

You are not allowed to view links. Register or Login to view.
Quote this message in a replyReply

Post: #2
thanks
Quote this message in a replyReply

Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)