View Single Post
  #3   Report Post  
SongBear
 
Posts: n/a
Default

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