Forum Discussion

Vicky13's avatar
Vicky13
Copper Contributor
Apr 06, 2020

Help with function

Hello, 

 

Can someone help me, i'm looking for an excel function.

 

I would like to limit the choice of a date with only one day (friday). That the person who's completing the doc, can only choose friday as the day of delevery the order.

 

Is it possible ?

 

Thank you !

 

Have a nice day,

 

Vicky

excel
Formulas and Functions

1 Reply

  • Savia's avatar
    Savia
    Iron Contributor
    Apr 06, 2020

    Vicky13 You could do this with a data validation rule (applied from Data => Data Validation).

     

    This custom rule would do it, for example: =WEEKDAY(cell, 2)=5

Resources