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

mgkaam

If I understand your question correctly, yes you can. Here is what I did to
test: In A2 I put a drop down with a list of numbers 1,2,3,4,5,6,7,etc. In
B2 I placed this formula =IF(ISNUMBER(A2),A2+1,""), after dragging it across
the columns to Column F for the five days of the week, I could select any of
the numbers in my drop down and it would fill across. I formatted my cells
as "ddd, dd" and my results were "Mon 14", "Tues 15" etc. Now not knowing
your layout I hope you can take some of this and make yours work!

Mike Rogers

"mgkaam" wrote:

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