week ending
 

Hi
I was hoping to get some help...in a timesheet i need to be able to have
excel work out the days and dates of the week based on the "fornight ending"
date...as in what ever date is put into the fornight ending date cell will
automatically adjust the day and date coloums.
I really hope that makes sense
thanx

week ending
 

Peter
Maybe this will help
If the "fornight ending" date is in cell A1 with a Value of 4/1/2008
put this formula into cell A2. =A1+1
"peter" wrote:

Hi
I was hoping to get some help...in a timesheet i need to be able to have
excel work out the days and dates of the week based on the "fornight ending"
date...as in what ever date is put into the fornight ending date cell will
automatically adjust the day and date coloums.
I really hope that makes sense
thanx

week ending
 

Simple solution (?)
Enter fortnight ending date in A1
Enter =TEXT(B2,"dddd") in A2 copy down to A15
Enter =A1-11 in B2
Enter =B2+1 in B3 & copy down to B15
Hope this helps


"peter" wrote:

Hi
I was hoping to get some help...in a timesheet i need to be able to have
excel work out the days and dates of the week based on the "fornight ending"
date...as in what ever date is put into the fornight ending date cell will
automatically adjust the day and date coloums.
I really hope that makes sense
thanx

week ending
 

thanx but how do i get it to work for the days of the week as was with the
dates....so when the week ending date is changed the days will change as well
as the dates...cause my weeking ending day is at the bottom

i tried
=TEXT(B2-13,"dddd") but that didnt work and i tried
=TEXT(B2,"dddd")-13 but that didnt work either
like tomorrow being the 4th of april it should end on a friday and start
saturday the 22...all the dates work but i cant figure how to have that for
the days
oh and its 13 cause its 2 full weeks
thanx

"Ron@Buy" wrote:

Simple solution (?)
Enter fortnight ending date in A1
Enter =TEXT(B2,"dddd") in A2 copy down to A15
Enter =A1-11 in B2
Enter =B2+1 in B3 & copy down to B15
Hope this helps


"peter" wrote:

Hi
I was hoping to get some help...in a timesheet i need to be able to have
excel work out the days and dates of the week based on the "fornight ending"
date...as in what ever date is put into the fornight ending date cell will
automatically adjust the day and date coloums.
I really hope that makes sense
thanx

week ending
 

oops nevermind i just figured it out i used
=TEXT(B14,"dddd") b14 being the first date of the fortnight and then just
dragged



"peter" wrote:

Hi
I was hoping to get some help...in a timesheet i need to be able to have
excel work out the days and dates of the week based on the "fornight ending"
date...as in what ever date is put into the fornight ending date cell will
automatically adjust the day and date coloums.
I really hope that makes sense
thanx