LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pai pai is offline
external usenet poster
 
Posts: 13
Default Date function - need help

On Mar 11, 3:38 am, Ann wrote:
Hello -

I have a column that has a date in it and I would like to create a function
that will display the following Wednesday's date in the next column.

Is this possible? If so, can someone please tell me how to write the
function?

Thanks in advance. Any help is greatly appreciated!


I am not sure what u want let take this example

A1 =11/march/2008 and if you want Tuesday in B1

Then The formula is =A1

Select the column
Go to Format
Then Cells
Numbers
Customs
Type DDD

Then Ok

Hopefully this will help You

Cheers
Hardeep Kanwar
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date function in ACCRINTM requires date format not available Pev Excel Worksheet Functions 4 October 13th 07 12:20 PM
MAX figure within a date range as a function of today()'s date irvine79 Excel Worksheet Functions 6 February 20th 07 03:28 PM
SUMIF within date range as a function of today()'s date irvine79 Excel Worksheet Functions 8 August 6th 06 05:55 PM
Date Function formula that will return the date of a specific week Greg Excel Worksheet Functions 4 June 12th 06 05:07 PM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 07:18 PM


All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"