using weekday formulas to automatically update a date range

  • Thread starter Thread starter ascott
  • Start date Start date
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?
 
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

Back
Top