Progressive Dating of Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shadyhosta - 29 Dec 2004 02:29 GMT

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 to this Message

RagDyer - 29 Dec 2004 02:59 GMT

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.

Signature

HTH,

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

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 to this Message

Shadyhosta - 29 Dec 2004 03:33 GMT

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.

> Put a Monday date in your first column.
> Right click and drag the fill handle aross as many columns as you estimate
[quoted text clipped - 9 lines]
> I can use Today (), Today() + 1, Today + 2, etc. What if I want this
> progression to skip weekend and holiday dates?

Reply to this Message

Peo Sjoblom - 29 Dec 2004 05:06 GMT

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

Signature

Regards,

Peo Sjoblom

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

>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
[quoted text clipped - 15 lines]
>> I can use Today (), Today() + 1, Today + 2, etc. What if I want this
>> progression to skip weekend and holiday dates?

Reply to this Message

Shadyhosta - 29 Dec 2004 03:29 GMT

> 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 to this Message