View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brooke Brooke is offline
external usenet poster
 
Posts: 28
Default Assigning consecutive dates

I received the answer on assigning consecutive dates but what can be done to
the formula

=INT($A$1+INT(ROW()-1)/30)

TO:

1. Not include weekends
2. Only assign the date to a certain person's name if there is multiple reps
on the spreadsheet.


Thank you so much.
Brooke Medvecky