Hi Artemis,
Dave Peterson gave you answers using worksheet formulas, the formatting
of the date relies on your system short date (Control Panel). You can modify
the format from that default.

But I expect the your question really concerns use in VBA, so you would
want to look up DATE from the Visual Basic Editor (VBE) in HELP from there.

More information on Date and Time can be found in
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/datetime.htm

In rereading the question, you definitely asked about VB, so the subject does
not match the question. Asking questions takes quite a bit of effort to ask a
question and get an answer the first time that is one that would work best for you.
If you asked for a specific format for instance you would get a specific answer.

Since you are taking Excel in University you certainly should be familiar with the
many excellent Excel tutorials available online to anyone.
http://www.mvps.org/dmcritchie/excel....htm#tutorials
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Artemis" wrote in message ...
Hello:

I am very new to coding and would appreciate some guidance. Does anyone
know or are there any sites which give sample code for VB in Excel and most
specifically having a spreadsheet "pull" the system date. I am going to
University plus working for accounting firms, so don't know where to search
on begin on looking to have a macro which displays the date code. Also, is
there any code for counting say to put an invoice number on a spreadsheet.
Thanks for all of your help.

--
Enjoy learning everything possible in life.