Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is fomula for entering dates that are 7 days apart?
I have a worksheet that I am entering payroll data for employees in and in
column A of Worksheet I am entering the payroll date with a Subtotal between each month. Our pay dates are every consecutive Friday. What is the formula/function that I can enter that will calculate the correct date in each row of column A without having to manually enter each Friday of a calendar year. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is fomula for entering dates that are 7 days apart?
Just add 7 on to the previous date, i.e.:
A2: =A1+7 Format the cell as you like it, then copy this down (assuming your first date in in A1) Hope this helps. Pete On Apr 10, 2:45*pm, G'maNancy wrote: I have a worksheet that I am entering payroll data for employees in and in column A of Worksheet I am entering the payroll date with a Subtotal between each month. *Our pay dates are every consecutive Friday. *What is the formula/function that I can enter that will calculate the correct date in each row of column A without having to manually enter each Friday of a calendar year. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Entering days in spreadsheet | Excel Discussion (Misc queries) | |||
Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |