Add Day to Date

's Computer Specifications

Hi all

I have in column I dates like 5/16/2006 which show in cells as 16-May-06
how could I get them to show as, Tue-16-may-06

Thanks in advance

Dave

's Computer Specifications

Just format the cell as ddd-dd-mmm-yy

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"DavidM" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi all
>
> I have in column I dates like 5/16/2006 which show in cells as 16-May-06
> how could I get them to show as, Tue-16-may-06
>
> Thanks in advance
>
> Dave
>
>
>
>
>
>
>

's Computer Specifications

Create a custom format that looks like this

Select the cells to format, click FORMAT in the menu and select CELLS and
click on the NUMBER tab. Select CUSTOM from the category list and enter the
following formatting mask in the TYPE: field:

ddd dd-mmmm-yy

for Fri 13-October-06

for a complete day of the week use dddd
for an abbreviated month use mm
--
Kevin Backmann

"DavidM" wrote:

> Hi all
>
> I have in column I dates like 5/16/2006 which show in cells as 16-May-06
> how could I get them to show as, Tue-16-may-06
>
> Thanks in advance
>
> Dave
>
>
>
>
>
>
>
>

's Computer Specifications

That was a fast reply

Thanks Bob

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Just format the cell as ddd-dd-mmm-yy
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "DavidM" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hi all
>>
>> I have in column I dates like 5/16/2006 which show in cells as 16-May-06
>> how could I get them to show as, Tue-16-may-06
>>
>> Thanks in advance
>>
>> Dave
>>
>>
>>
>>
>>
>>
>>
>
>

's Computer Specifications

Thanks Kevin

"Kevin B" <(E-Mail Removed)> wrote in message
news:7ABFB965-9AE1-42C5-8B9C-(E-Mail Removed)...
> Create a custom format that looks like this
>
> Select the cells to format, click FORMAT in the menu and select CELLS and
> click on the NUMBER tab. Select CUSTOM from the category list and enter
> the
> following formatting mask in the TYPE: field:
>
> ddd dd-mmmm-yy
>
> for Fri 13-October-06
>
> for a complete day of the week use dddd
> for an abbreviated month use mm
> --
> Kevin Backmann
>
>
> "DavidM" wrote:
>
>> Hi all
>>
>> I have in column I dates like 5/16/2006 which show in cells as 16-May-06
>> how could I get them to show as, Tue-16-may-06
>>
>> Thanks in advance
>>
>> Dave
>>
>>
>>
>>
>>
>>
>>
>>

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

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