The DAY ( ) functiorl returns a number between 1 and 31 that corresponds to the day component of a specified date.
Syntax:
DAY(serial‑number)
Serial‑number:
The date (or a string representation of the date) you want to work with.
Example:
If today is Sep. 19,2011, type this formula Jn any cell
=DAY("9/19/2011")
Returns: 19
Syntax:
DAY(serial‑number)
Serial‑number:
The date (or a string representation of the date) you want to work with.
Example:
If today is Sep. 19,2011, type this formula Jn any cell
=DAY("9/19/2011")
Returns: 19
Stands back from the keyboard in azameemnt! Thanks!
ReplyDeleteWeeeee, what a quick and easy soluiotn.
ReplyDelete