View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erik[_6_] Erik[_6_] is offline
external usenet poster
 
Posts: 18
Default More date issues

I should probably gather a bunch of my problems and ask about them all at once

I have a row of cells that are column headers for the days of the week. Before each day(text) is a blank cell for the date(03/01/04). I would like to be able to enter the date in the first blank date cell and have the other 6 fill automatically. The closest built in formula I could find was Workday(), but that only accounts for Mon - Fri. I need to figure all seven days of the week

Erik