excel training onsite - Date functions

The UK's most regular instructor-led training courses.
Training information: excel training onsite · Excel-courses-london · VBA training in London

Resolved · Low Priority · Version Standard

Date functions

Vijay has attended:
No courses

by - delegate Vijay [2 posts] (2007 Aug 22 Wed, 07:40) Reply

How to extract Start date of a week in a year if weeknumber is known

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Date functions

by - trainer Anthony gold contributer [113 posts] (2007 Sep 25 Tue, 10:24) Reply

Hi Vijay. This depends on what year you're talking about as the start date of, say week 1, in 2007 is going to be different to that of 2006. Plus Excel makes a distinction between starting a week on a Sunday or a Monday. However, the discussion here:

http://www.developersdex.com/vb/message.asp?p=2677&r=5955664

...should give you a few pointers, particularly the VBA and worksheet function examples.

Hope this helps,

Anthony

RE: Date functions

by - delegate Vijay [2 posts] (2007 Sep 28 Fri, 12:54) Reply

Dear Sir,
Thank you very much for your help.

This works perfectly.

with warm Regards,

Vijay

· Microsoft Excel Features and Functions for Accountants
· Identifying Suitable Candidates For VBA For Excel Training
· Reasons Why VBA for Excel Training Fails
· How Excel Training Can Improve Your Company's Sales Process
· How to Create Better Excel Spreadsheets: Part Four

Excel tip:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips