using weekday formulas to automatically update a date range
 

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?

using weekday formulas to automatically update a date range
 

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


--
Biff
Microsoft Excel MVP


"ascott" wrote in message
...
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?