how do i calculate every 12 weekdays in a spreadsheet?

itoikenza

hi, id like to know how do i calculate every 12 weekdays (mon. to fri.) via a spreadsheet? is there a formula i can use that will always give me the 12th weekday after every date one after another in one column?

Integral

Unfortunately there is not a specific function for every strange thing people want to do. You need to work it out your self. Sounds do-able but may take some time. You could explore the VB macro editor, assuming you can write a program.

Good luck

D H

If it wasn't for holidays it would be pretty easy. Add 16 days (2 days + 2 weeks), then add an additional two days if it is Thursday or Friday. Those holidays pretty much mandate writing a VB macro, however.

TheoMcCloskey

Take a look at the WORKDAY function (under Date & Time functions). It returns the date serial number of the date before or after a specified number of workdays. It also allows for consideration of user-supplied holidays.

itoikenza

thanks... then let's hope lotus symphony has it. as i've taken a liking to it recently...

edit: thanks i figured it all out, just one more, how do i add the name of each day? ex. monday

montoyas7940

In a different life I used this quite a bit. I hope it helps.
http://www.excelforum.com/

MATLABdude

I think this example should work:

1) First column, put in a date, and make sure Excel recognizes it as a date (you can change the formatting later). e.g. 9-Jul-12

2) In the second column, add 12 to the cell with the previous value. e.g. enter "=A1+12" (without quotes) in the new cell, assuming the first cell was A1

You can just add and subtract days from dates in Excel (and you can copy and paste the "previous column + 12" formula to make things really easy).