Difference between revisions of "Manuals/calci/DEGREES"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
− | <div style="font-size:30px">''' | + | <div style="font-size:30px">'''DATES(yy,mm,dd)'''</div><br/> |
− | *' | + | *'yy' represents the year |
+ | *'mm' is the month of the year | ||
+ | *'dd'is the date. | ||
==Description== | ==Description== | ||
− | *This function gives the | + | *This function gives the sequential serial number for the given date. |
− | * | + | *Here 'yy' represents the year and it should start from 1 or more than 1. |
− | * | + | *'mm' is the month of the year and it is from 1 to 12(January to December). |
+ | *'dd' is the date of the month of the year and it is from 1 to 31. | ||
==Examples== | ==Examples== | ||
− | * | + | *DATE(99,2,1)=2/1/99 |
− | + | *DATE(1600,12,31)=12/31/1600 | |
− | |||
− | * | ||
==See Also== | ==See Also== | ||
− | *[[Manuals/calci/ | + | *[[Manuals/calci/DATEVALUE | DATEVALUE ]] |
− | *[[Manuals/calci/ | + | *[[Manuals/calci/DAYS | DAYS]] |
− | |||
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] | [http://en.wikipedia.org/wiki/Complex_number| Complex Numbers] |
Revision as of 00:38, 14 November 2013
DATES(yy,mm,dd)
- 'yy' represents the year
- 'mm' is the month of the year
- 'dd'is the date.
Description
- This function gives the sequential serial number for the given date.
- Here 'yy' represents the year and it should start from 1 or more than 1.
- 'mm' is the month of the year and it is from 1 to 12(January to December).
- 'dd' is the date of the month of the year and it is from 1 to 31.
Examples
- DATE(99,2,1)=2/1/99
- DATE(1600,12,31)=12/31/1600