Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a biweekly date
Is there a way to use a formula to calculate a biweekly pay day? For
example, I want a spreadsheet that automatically puts the date for every other Wednesday throughout the year?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a biweekly date
Automatically how? In what way, what would you do to trigger this date
entry? -- Regards, Peo Sjoblom "TimT" wrote in message ... Is there a way to use a formula to calculate a biweekly pay day? For example, I want a spreadsheet that automatically puts the date for every other Wednesday throughout the year?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate a biweekly date
If you mean a table with those dates:
enter the date of the first Wednesday in A1 In A2, enter: =A1+14 Copy down as far as needed -- Kind regards, Niek Otten "TimT" wrote in message ... Is there a way to use a formula to calculate a biweekly pay day? For example, I want a spreadsheet that automatically puts the date for every other Wednesday throughout the year?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate the number of days from date received | Excel Worksheet Functions | |||
calculate date differences in years and months | Excel Worksheet Functions | |||
Calculate date | Excel Worksheet Functions | |||
How do I use the IF function to calculate date | Excel Discussion (Misc queries) | |||
What is the formula to calculate Age when I have Date of Birth? | Excel Worksheet Functions |