# How to set the Default value of a Date/Time column to next Friday?

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?

-

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!

-
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
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

For a 2 weeks Advance do this:

``````=Today+14
``````
-
not what I asked but ok..... – Abe Miessler Sep 11 '12 at 21:40
``````=Today+(6-MOD(WEEKDAY(Today),7))
``````

worked

-
``````=DATE(YEAR(Today),MONTH(Today)+1,(5-MOD(WEEKDAY(DATE(YEAR(Today),MONTH(Today)+1,1)),7)+8))