week ending

[peter]

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

 

[Mike]

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

 

[Ron@Buy]

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]

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

 

[peter]

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