| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically update pivot tables when dynamic named range is expa | Excel Discussion (Misc queries) | |||
| Have date automatically update each time I open the spreadsheet | Excel Discussion (Misc queries) | |||
| How do I automatically update a chart range in Excel | Excel Discussion (Misc queries) | |||
| How do I get the date to automatically update | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
Linear Mode
