View original (French)

Formula

Solved
lou2411 Posted messages 155 Status Member -  
lou2411 Posted messages 155 Status Member -
Hello,

I would like to have a date in b2, for example, 13-01-14, and in cell a1, the day of the week is automatically displayed. Is this possible with a formula?

2 answers

  1.
    MrYAU31 Posted messages 4631 Status Member 1 630
     
    Hello,
    No need for a formula.
    Just put “=B2” in A1 and change the format of A1 to Custom and enter “jjjj” (without the quotes).
    0
  2. lou2411 Posted messages 155 Status Member
     
    okay, thanks
    0