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