Hi -
I am looking for a function (or at least a push in the right direction)
to help me achieve the following.

I have a spreadsheet which has several columns of data. The three
columns I care about all involve dates, but they are not stored as
dates, but as strings in this format:

Jun Wk 1
Jun Wk 2
Jul Wk 1
Jul Wk 2
July Wk 5
Aug Wk 1

Etc...

What I need to be able to do is (IF the "date" in the column, ie Jun Wk
1, is before today's date, delete that row) so that today the column
would read: July Wk 2 (and the following dates) since that would be the
most recent date. Can anyone help with this? Thanks in advance,
Steve

How are your weeks defined? Are they always 7 days, do they always begin on
Sunday (or Monday), do you use ISO week numbers, etc. For example, July 2006
began on a Saturday. Is that a 1-day Week 1?

I can almost certainly write this function for you, but I must know how to
figure out which days are in Week 1 vs. Week2 for any month.

Hutch

"nemadrias" wrote:

> Hi -
> I am looking for a function (or at least a push in the right direction)
> to help me achieve the following.
>
> I have a spreadsheet which has several columns of data. The three
> columns I care about all involve dates, but they are not stored as
> dates, but as strings in this format:
>
> Jun Wk 1
> Jun Wk 2
> Jul Wk 1
> Jul Wk 2
> July Wk 5
> Aug Wk 1
>
> Etc...
>
> What I need to be able to do is (IF the "date" in the column, ie Jun Wk
> 1, is before today's date, delete that row) so that today the column
> would read: July Wk 2 (and the following dates) since that would be the
> most recent date. Can anyone help with this? Thanks in advance,
> Steve
>
>

Tom -
Thanks for your reply, I was actually able to figure this out. I
simply assigned an integer to each week of each month, and then
compared that to an integer assigned to the current month. If x < y
kind of a thing, and it seems to work fine. Thanks anyways,
Steve

Tom Hutchins wrote:
> How are your weeks defined? Are they always 7 days, do they always begin on
> Sunday (or Monday), do you use ISO week numbers, etc. For example, July 2006
> began on a Saturday. Is that a 1-day Week 1?
>
> I can almost certainly write this function for you, but I must know how to
> figure out which days are in Week 1 vs. Week2 for any month.
>
> Hutch
>
> "nemadrias" wrote:
>
> > Hi -
> > I am looking for a function (or at least a push in the right direction)
> > to help me achieve the following.
> >
> > I have a spreadsheet which has several columns of data. The three
> > columns I care about all involve dates, but they are not stored as
> > dates, but as strings in this format:
> >
> > Jun Wk 1
> > Jun Wk 2
> > Jul Wk 1
> > Jul Wk 2
> > July Wk 5
> > Aug Wk 1
> >
> > Etc...
> >
> > What I need to be able to do is (IF the "date" in the column, ie Jun Wk
> > 1, is before today's date, delete that row) so that today the column
> > would read: July Wk 2 (and the following dates) since that would be the
> > most recent date. Can anyone help with this? Thanks in advance,
> > Steve
> >
> >