Date VBA

terilad

Guest

Posts: n/a

3rd Mar 2010

Hi,

I need help with a problem.

I have a range of cells C6 to I6 tith the date in them Mon to Sun, below
these cells I have input in some of the cell an X to mark the days a person
is taking a holiday. so Wed, Thurs, Fri the cells below are marked with an X
to indicate a holiday, what I am looking to do is report on another sheet the
dates of the holiday this person is taking, so it would report 10th, 11th and
12th Feb 2010 in cell A1 to indicate the dates of the holiday.

Can anyone help me with this i'm stuck.

Many thanks

Mark

« ? Index of Names | add years to a cell »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
what method to use to add 1 day to a date (hotel reservation for one night by clicking on calender) and get it displayed in date formate in a textbox for departure date?	Amanda	Microsoft VB .NET	2	10th Oct 2006 06:52 AM
Link date to a table with Date Range (Eff Date and term date)	=?Utf-8?B?S2V2aW4gUmVlZA==?=	Microsoft Access	1	31st Aug 2006 04:23 PM
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent	Mike Saifie	Microsoft Access Form Coding	1	9th Mar 2006 01:08 AM
Run Query from date to date, Print the from date to date in the header of the report?	Dustin Swartz	Microsoft Access Queries	1	25th Jan 2005 07:06 PM
Date fields automatically changing when today date matches date field entry.Help!	Brian Cassin	Microsoft Access Forms	1	15th Nov 2003 01:51 PM