excel training onsite - Date functions

Resolved · Low Priority · Version Standard

Wed 22 Aug 2007, 07:40 Delegate Vijay said...

Vijay has attended:
No courses

Date functions

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

Tue 25 Sep 2007, 10:24 Trainer Anthony said...

RE: Date functions

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

Fri 28 Sep 2007, 12:54 Delegate Vijay said...

RE: Date functions

Dear Sir,
Thank you very much for your help.

This works perfectly.

with warm Regards,

Vijay

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

excel training onsite - Date functions

Date functions

RE: Date functions

RE: Date functions

Excel articles

Excel tip:

Select only cell that contain text to lock format