View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Monique
 
Posts: n/a
Default Excel Workday Function with another function

Is there a way to use workday function and also list the dates automatically?

i.e.

a1 = 5/1

b2= all working days until the last working day of the month. (Friday) I
have seen a formula that does this:
=if(a1="","",if(month(a1+1=month(a$1),a1+1,""))
but not with the workday function. It is not automatic and has to be dragged
over. I am not sure if this is possible, or I just don't know what order to
put them in.

I would like it to fill the working days automatically by entering the date
for one cell.