If you find any post useful then, please do share with others. Thanks!

Popular Posts

Contact

Email me

Need help and that also free? I like to learn this way, in case of any question or for a small task, please feel free to email me with details and example data, if required.

Friday, October 25, 2013

Roman & Datedif function

Roman
The Roman function converts a number to Roman format.
=Roman(9) = IX
1
I
2
II
3
III
4
IV
5
V
6
VI
7
VII
8
VIII
9
IX
10
X


Datedif
This function calculates the difference between two dates in a variety of interims like number of years, months or days.
=DATEDIF(Start Date, End Date, Interim)
Here the Start Date must be less than the End Date and interim could be m for months, d for days and y for years.
And the if we are using the interim text directly in the formula then it should be in double quotes

No comments:

Post a Comment