View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mgkaam mgkaam is offline
external usenet poster
 
Posts: 6
Default Weekending date issue

I have a timesheet that I have a weekending date field setup with a Date
ValidationList drop down box with all the weekending dates. What I would
like to do is that I have the weekdays i.e. Monday, Tuesday, Wednesday....
all in there own cells and i would like to calculate off the weekending date
so that Monday has the monday date of that week and so forth. Is it possible
to to calculate off a list box? or do I need to setup a = function and how
would I do that?

Michelle