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?? |
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?? |
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?? |
All times are GMT +1. The time now is 03:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com