Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 3 down vote favorite
1

I did some poking around in the documentation for Calculated field formulas, but I don't see anything that would help me do this. Does anyone know if it can be done? Can you point me in the right direction?

share|improve this question

2 Answers

up vote 3 down vote accepted

In the Default option you can use [Today] plus some number of days... you would have to find the weekday as an integer, compare it to the weekday of Today as an integer, and do some math to get something to add to [Today] to make it next Friday. I'll see if i can find the right formula for it in the mean time.

Edit: ok so you can use WEEKDAY([Today]) to return an integer from 1 (sunday) to 7 (saturday) (Options of WEEKDAY Function), and depending on how you want to determine what 'next week' is, you would add write the formula as something like...

=[Today] + (6 - MOD(WEEKDAY([Today]),7)) + 7

Haven't tested it but that should work!

share|improve this answer
2  
I ended up using this method which seems a little shorter and also seems to work: =Today+6-WEEKDAY(Today) – Abe Miessler Jun 8 '12 at 21:45
1  
The short version isn't working friday or saturday. Where it'll give today or yesterday, which isn't consistent with next friday. – Per Jakobsen Jun 11 '12 at 8:13
Quick breakdown on what each version does: long version; takes the weekday number and rearranges it as 0 saturday -> 6 friday, 6 subtracted by it to get the number of days to get to THIS week's friday (so with this setup saturday gives you two full work weeks) and added by 7 to give you the next friday. The short version; return THIS week's friday where friday returns itself and saturday returns the day before. – Zork Jun 11 '12 at 12:45
up vote -2 down vote

For a 2 weeks Advance do this:=

=Today+14

share|improve this answer
not what I asked but ok..... – Abe Miessler Sep 11 '12 at 21:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.