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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top