Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35
Default How To INCREMENT days of the week? like mon,tues,wed,etc??

Is there is a function or process where you can increment the days of
the week AS WELL as the date?

Like
Monday Aug 1, 2009
Tuesday Aug 2, 2009
etc..

or even JUST the days of the week?
like
Monday
Tuesday
Wednesday
etc
??

p.s. Using Excel '97


  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How To INCREMENT days of the week? like mon,tues,wed,etc??

Yes, there is a function in Excel that can increment the days of the week as well as the date. You can use the "WEEKDAY" function to achieve this.

To increment the days of the week along with the date, follow these steps:
  1. Enter the starting date in a cell, for example, A1.
  2. In the cell next to it, enter the formula
    Formula:
    "=A1+1" 
    . This will add one day to the date in cell A1.
  3. To display the day of the week along with the date, use the "TEXT" function. For example, in cell C1, enter the formula
    Formula:
    "=TEXT(A1,"dddd mmm dyyyy")" 
    . This will display the date in the format "Monday Aug 1, 2009".
  4. In the cell next to it, enter the formula
    Formula:
    "=C1+1" 
    . This will add one day to the date in cell C1 and display the next day of the week.

To increment only the days of the week, follow these steps:
  1. Enter the starting day of the week in a cell, for example, A1.
  2. In the cell next to it, enter the formula
    Formula:
    "=A1+1" 
    . This will add one day to the day of the week in cell A1.
  3. To display the day of the week, use the "TEXT" function. For example, in cell C1, enter the formula
    Formula:
    "=TEXT(A1,"dddd")" 
    . This will display the day of the week in the format "Monday".
  4. In the cell next to it, enter the formula
    Formula:
    "=C1+1" 
    . This will add one day to the day of the week in cell C1 and display the next day of the week.

Note that the "WEEKDAY" function can also be used to determine the day of the week for a given date.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default How To INCREMENT days of the week? like mon,tues,wed,etc??

Robert Blass wrote...
Is there is a function or process where you can increment the days of
the week AS WELL as the date?

Like
Monday Aug 1, 2009
Tuesday Aug 2, 2009
etc..

or even JUST the days of the week?
like
Monday
Tuesday
Wednesday
etc
??


Something like entering the following formula into cell A1.

A1:
=TEXT("Jul 31, 2009"+ROW(),"dddd mmm d, yyyy")

Then fill A1 down into A2:A30 or so.
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,934
Default How To INCREMENT days of the week? like mon,tues,wed,etc??

You could also avoid using a formula by putting your date into a cell,
copying it down and then Custom Formatting the cells with this...

dddd, mmm d, yyyy

or any other formatting pattern of your choice.

--
Rick (MVP - Excel)


"Robert Blass" wrote in message
...
Is there is a function or process where you can increment the days of
the week AS WELL as the date?

Like
Monday Aug 1, 2009
Tuesday Aug 2, 2009
etc..

or even JUST the days of the week?
like
Monday
Tuesday
Wednesday
etc
??

p.s. Using Excel '97



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default How To INCREMENT days of the week? like mon,tues,wed,etc??

For just the days of the week...

You can enter Monday in the first cell then just drag down and Excel will
increment them.

If you want a formula:

=TEXT(ROWS(A$1:A2),"dddd")

Copy down

For the days and the date, it depends on what dates you want.

--
Biff
Microsoft Excel MVP


"Robert Blass" wrote in message
...
Is there is a function or process where you can increment the days of
the week AS WELL as the date?

Like
Monday Aug 1, 2009
Tuesday Aug 2, 2009
etc..

or even JUST the days of the week?
like
Monday
Tuesday
Wednesday
etc
??

p.s. Using Excel '97






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default How To INCREMENT days of the week? like mon,tues,wed,etc??

Hi,

1. enter the first date
2. format it to dddd mmm d, yyyy custom format - choose Format, Cells,
Number tab, Custom, and enter the above codes in the Type box, click OK.
3. Drag the fill handle down - the bottom right corner square on the cell
with the date.

If you only want weekdays -
4. Open the paste options drops down (small clipboard icon at the bottom
left of the filled range), and choose Weekdays

If this helps, please click the Yes button

Cheers,
Shane Devenshire
"Robert Blass" wrote:

Is there is a function or process where you can increment the days of
the week AS WELL as the date?

Like
Monday Aug 1, 2009
Tuesday Aug 2, 2009
etc..

or even JUST the days of the week?
like
Monday
Tuesday
Wednesday
etc
??

p.s. Using Excel '97



Reply
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
days of the week formulas Bob Excel Worksheet Functions 21 March 7th 08 10:16 PM
5 working days of a week deepika :excel help[_2_] Excel Discussion (Misc queries) 3 January 31st 08 09:37 PM
Re Change 5 week days to 7 days in this formula pano Excel Worksheet Functions 7 February 1st 07 05:20 PM
7 days of the week James C Excel Discussion (Misc queries) 8 October 10th 05 04:14 AM
Days of the week. Johan Bornman Excel Worksheet Functions 1 November 10th 04 06:25 PM


All times are GMT +1. The time now is 04:27 PM.

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

About Us

"It's about Microsoft Excel"