Forum Discussion

ConsueloViramon's avatar
ConsueloViramon
Qrew Member
3 years ago

Future date, formatted weekday, Month, day

Hi there,

I'm a complete beginner, so please bear with me.
I need a field that shows Weekday, Month and day, with seven days in advance, except for Sundays and Saturdays. 

So if today is Monday, Jan 1st, I need it to show Monday, Jan 8th. 
If today is Saturday, Jan 6th, I need it to show Monday, Jan 8th.

I know I need a date/Formula field, but I'm not sure what to put in the Formula. 

Thanks in advance!


------------------------------
Consuelo Viramonte
------------------------------
Formulas and functions
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    3 years ago
    Hi Consuelo, 

    You can indeed look 7 weekdays in advance using the WeekDayAdd function, there are a few examples of how to set up a formula using it in the entry for WeekDayAdd in our formula function guide. For example you could do something like if your field was named Start Date:

    WeekdayAdd([Start Date], 7) 

    ------------------------------
    Evan Martinez
    ------------------------------