Date formatting in Functions

Resolved · Low Priority · Version Standard

Lisa has attended:
Excel VBA course

by - delegate Lisa [1 post] (2008 Mar 19 Wed, 13:55) Reply

If creating a function using date, how do you get the answer to be formatted in date format?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Date formatting in Functions

by - trainer Pete platinum contributer [799 posts] (2008 Mar 31 Mon, 11:07) Edited on 2008 Mar 31 Mon, 11:09 Reply

Hi Lisa, Welcome to the forum, Thank you for your post, in answer to your question, if the result is going to be in a date style, ie separated by hyphens (-) or the forward slash (/) Excel will recognise that it is to be a date, however in all other cases the number of days from the 1/1/1900 will be returned, this is more a question of the formatting properties of the receiving cell rather than the actual function itself. I suppose you could add further commands to the function if you desired or you could format the receiving cell/s and then the input will automatically be fomatted as whatever date style you require whenever the cell is populated. I hope that helps, best regards Pete

· MS Excel: Excel At Making The Most Of Your Christmas
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

Please browse our web site to find out more about
course excel training vba london and other Microsoft training courses.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips