Getting Started

 View Only
  • 1.  Future date, formatted weekday, Month, day

    Posted 09-23-2022 13:09
    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
    ------------------------------


  • 2.  RE: Future date, formatted weekday, Month, day

    Posted 09-28-2022 13:45
    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
    ------------------------------