The Worday Function

[Guest]

I have used the Workday function in Column s D and E to enter a series of
dates to conform to a schedule: as follows (picking things up from Row 26)

D
E
26 =WORKDAY(D23,3) [This yields 2/15Tues] =WORKDAY(D26,2) [Yields
2/17Thur]

27 =WORKDAY(E26,1) [Yields 2/18Fri] =WORKDAY(D27,1)
[Yields 2/21Mon]

The problem: In D28, I need a fomula that yields 2/21Mon/2/23Wed
and in E28 the fomrula should yield 2/22Tue/2/24Thurs

I am at a loss to figure out how to get a formula entering two different
days in the same cell.

Many Thanks
Kevin

 

[Guest]

KEVIN
Formulas first, then results. I used two rows here to represent row 28
because the fromula is so long that it wraps here. E and F collumns do not
show as directly over their columns here, either. You can probably figure it
out. I added references to the day spans to add flexibility, you can change
day spans without going into each formula.

Hope this helps - let us know.
SongBear

D E F
23 38393
24
25
26 =WORKDAY(D23,F31) =WORKDAY(D26,F32)
27 =WORKDAY(E26,F33) =WORKDAY(D27,F34)
28 ="From " & TEXT(WORKDAY(E27,F35),"m/dd dddd") & " to "&
TEXT(WORKDAY(E27,F35+F36),"m/dd dddd")
28 ="From " & TEXT(WORKDAY(E27,F37),"m/dd
dddd") & " to "& TEXT(WORKDAY(E27,F37+F36),"m/dd dddd")
29
30
31 First date span 3
32 Second date span 2
33 Third date span 1
34 Fourth date span 1
35 Fifth date span 0
36 Sixth date span 2
37 Seventh Date Span 1
38 Eighth date span 2



D E F
23 2/10/2005
24
25
26 2/15 Tuesday 2/17 Thursday
27 2/18 Friday 2/21 Monday
28 From 2/21 Monday to 2/23 Wednesday From 2/22 Tuesday to 2/24 Thursday
29
30
31 First date span 3
32 Second date span 2
33 Third date span 1
34 Fourth date span 1
35 Fifth date span 0
36 Sixth date span 2
37 Seventh Date Span 1
38 Eighth date span 2

 

[Guest]

BTW, Kevin'
Thanks, interesting problem, I hadn't used the Workday function before.
SongBear

 

[Bob Phillips]

Not sure I full get this, but does this doe it

D28: =TEXT(E27,"m/dd ddd")&"/"&TEXT(WORKDAY(E27,2),"m/dd ddd")
E28: =TEXT(WORKDAY(E27,1),"m/dd
ddd")&"/"&TEXT(WORKDAY(WORKDAY(E27,1),2),"m/dd ddd")

 

[Guest]

Thanks to both of you - I am now good to go.

Not sure I full get this, but does this doe it

D28: =TEXT(E27,"m/dd ddd")&"/"&TEXT(WORKDAY(E27,2),"m/dd ddd")
E28: =TEXT(WORKDAY(E27,1),"m/dd
ddd")&"/"&TEXT(WORKDAY(WORKDAY(E27,1),2),"m/dd ddd")

--
HTH

Bob Phillips

I have used the Workday function in Column s D and E to enter a series of
dates to conform to a schedule: as follows (picking things up from Row 26)

D
E
26 =WORKDAY(D23,3) [This yields 2/15Tues] =WORKDAY(D26,2) [Yields
2/17Thur]

27 =WORKDAY(E26,1) [Yields 2/18Fri] =WORKDAY(D27,1)
[Yields 2/21Mon]

The problem: In D28, I need a fomula that yields 2/21Mon/2/23Wed
and in E28 the fomrula should yield 2/22Tue/2/24Thurs

I am at a loss to figure out how to get a formula entering two different
days in the same cell.

Many Thanks
Kevin

 

[Guest]

Happy to help, it was an interesting little problem.
Thanks
SongBear

Thanks to both of you - I am now good to go.

Not sure I full get this, but does this doe it

D28: =TEXT(E27,"m/dd ddd")&"/"&TEXT(WORKDAY(E27,2),"m/dd ddd")
E28: =TEXT(WORKDAY(E27,1),"m/dd
ddd")&"/"&TEXT(WORKDAY(WORKDAY(E27,1),2),"m/dd ddd")

--
HTH

Bob Phillips

I have used the Workday function in Column s D and E to enter a series of
dates to conform to a schedule: as follows (picking things up from Row 26)

D
E
26 =WORKDAY(D23,3) [This yields 2/15Tues] =WORKDAY(D26,2) [Yields
2/17Thur]

27 =WORKDAY(E26,1) [Yields 2/18Fri] =WORKDAY(D27,1)
[Yields 2/21Mon]

The problem: In D28, I need a fomula that yields 2/21Mon/2/23Wed
and in E28 the fomrula should yield 2/22Tue/2/24Thurs

I am at a loss to figure out how to get a formula entering two different
days in the same cell.

Many Thanks
Kevin