N
newstrom
There are two way I can do what I'd like so I'll give both examples and
see what can be done. I have to create a bid sheet to be printed that
is idiot proof in showing important dates that are coming up.
Version 1:
I have three columns that will show on print out:
Action Due Action Time Type of Action
I have eight columns in which I put various dates:
RFQ RFQ Time Walk Through WT Time Mtg Mtg Time RFP
RFP Time
In a perfect world I would like to find the earliest date that is prior
to (today) which I found the earliest date using MIN but formula would
not allow me to make it <Today. Once that date is found I want to take
that date, corresponding time, and column heading and place it in the
three corresponding action columns. If the date is past today I just
want the action columns to stay blank. I have not been able to find any
type of formula to link the cells randomly.
Version 2:
Remove the action columns and just highlight the earliest date &
corresponding time. I tried the conditioning format tool but have
never been able to get it to work and can't find any help in the help
menu. Plus I have the same problem finding the earliest date that is
before today.
Any help would be appreciated. Note I am a novice user so complicate
sequal language needs to be spelled out for me. Usually when I get
those responses I cut and paste and make changes as needed until I get
it to work.
see what can be done. I have to create a bid sheet to be printed that
is idiot proof in showing important dates that are coming up.
Version 1:
I have three columns that will show on print out:
Action Due Action Time Type of Action
I have eight columns in which I put various dates:
RFQ RFQ Time Walk Through WT Time Mtg Mtg Time RFP
RFP Time
In a perfect world I would like to find the earliest date that is prior
to (today) which I found the earliest date using MIN but formula would
not allow me to make it <Today. Once that date is found I want to take
that date, corresponding time, and column heading and place it in the
three corresponding action columns. If the date is past today I just
want the action columns to stay blank. I have not been able to find any
type of formula to link the cells randomly.
Version 2:
Remove the action columns and just highlight the earliest date &
corresponding time. I tried the conditioning format tool but have
never been able to get it to work and can't find any help in the help
menu. Plus I have the same problem finding the earliest date that is
before today.
Any help would be appreciated. Note I am a novice user so complicate
sequal language needs to be spelled out for me. Usually when I get
those responses I cut and paste and make changes as needed until I get
it to work.