Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Shadyhosta
 
Posts: n/a
Default Progressive Dating of Columns

Ok, if I want to date successive column headings to return progressive dates,
I can use Today (), Today() + 1, Today + 2, etc. What if I want this
progression to skip weekend and holiday dates?
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

Put a Monday date in your first column.
Right click and drag the fill handle aross as many columns as you estimate
you'll need.
When you release the mouse, you'll see a pop-up menu with one of the choices
to fill the range with "weekdays".

As for holidays, only you know what's a holiday for your firm (Veteran's
Day - Friday after Thanksgiving).
You'll have to adjust for them manually.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Shadyhosta" wrote in message
...
Ok, if I want to date successive column headings to return progressive
dates,
I can use Today (), Today() + 1, Today + 2, etc. What if I want this
progression to skip weekend and holiday dates?

  #3   Report Post  
Shadyhosta
 
Posts: n/a
Default



"Shadyhosta" wrote:

Ok, if I want to date successive column headings to return progressive dates,
I can use Today (), Today() + 1, Today + 2, etc. What if I want this
progression to skip weekend and holiday dates?

  #4   Report Post  
Shadyhosta
 
Posts: n/a
Default

I don't understand why a "Monday" date. I want my first column to be
today() + 1. I tried this formula, and then tried right clicking on the
cell, but only got a drop down menu, and was unable to drag.

"RagDyer" wrote:

Put a Monday date in your first column.
Right click and drag the fill handle aross as many columns as you estimate
you'll need.
When you release the mouse, you'll see a pop-up menu with one of the choices
to fill the range with "weekdays".

As for holidays, only you know what's a holiday for your firm (Veteran's
Day - Friday after Thanksgiving).
You'll have to adjust for them manually.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Shadyhosta" wrote in message
...
Ok, if I want to date successive column headings to return progressive
dates,
I can use Today (), Today() + 1, Today + 2, etc. What if I want this
progression to skip weekend and holiday dates?


  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

You need to refer to the previous cell if you want to add 1 to each day (or
using the COLUMN function)
put TODAY() (or press ctrl + ;) in A1, in B1 put this formula and copy
across

=IF(A1="","",IF(WEEKDAY(A1+1,2)5,A1+7-WEEKDAY(A1-2),A1+1))

will skip weekends but you obviously have to fix the holidays manually or
put them in a list and
add some conditions if the dates match dates in the list

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Shadyhosta" wrote in message
...
I don't understand why a "Monday" date. I want my first column to be
today() + 1. I tried this formula, and then tried right clicking on the
cell, but only got a drop down menu, and was unable to drag.

"RagDyer" wrote:

Put a Monday date in your first column.
Right click and drag the fill handle aross as many columns as you
estimate
you'll need.
When you release the mouse, you'll see a pop-up menu with one of the
choices
to fill the range with "weekdays".

As for holidays, only you know what's a holiday for your firm (Veteran's
Day - Friday after Thanksgiving).
You'll have to adjust for them manually.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Shadyhosta" wrote in message
...
Ok, if I want to date successive column headings to return progressive
dates,
I can use Today (), Today() + 1, Today + 2, etc. What if I want this
progression to skip weekend and holiday dates?




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
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 09:13 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 07:37 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 09:13 PM
Averaging columns rhodesv New Users to Excel 1 December 16th 04 09:14 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 06:40 PM


All times are GMT +1. The time now is 10:23 AM.

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"