using weekday formulas to automatically update a date range

A

ascott

I am creating a biweekly timesheet for my company which includes all 7 days
of the week,
I want to be able to enter one date and have the rest of the spreadsheet
update the dates automatically in order.
I am trying to use the weekday functions to do this however, it is not
returning the right dates.
can anyone help me with this?
 
T

T. Valko

Not enough info.

Are you wanting to enter the first date of the 2 week pay period and then
have the rest of the dates listed?

If so:

A1 = some date

Enter this formula in A2 and copy down to A14:

=A1+1
 
Top