Home |
Search |
Today's Posts |
#1
|
|||
|
|||
The Worday Function
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 |
#2
|
|||
|
|||
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 "Kevin" wrote: 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 |
#3
|
|||
|
|||
BTW, Kevin'
Thanks, interesting problem, I hadn't used the Workday function before. SongBear "Kevin" wrote: 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 |
#4
|
|||
|
|||
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 "Kevin" <ksorei at yahoo.com wrote in message ... 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 |
#5
|
|||
|
|||
Thanks to both of you - I am now good to go.
"Bob Phillips" wrote: 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 "Kevin" <ksorei at yahoo.com wrote in message ... 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 |
#6
|
|||
|
|||
Happy to help, it was an interesting little problem.
Thanks SongBear "Kevin" wrote: Thanks to both of you - I am now good to go. "Bob Phillips" wrote: 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 "Kevin" <ksorei at yahoo.com wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |