View original (French)

First day of the year

Solved
nathan01983 Posted messages 30 Registration date   Status Member Last intervention   -  
nathan01983 Posted messages 30 Registration date   Status Member Last intervention   -

Hello

Do you know how to find the first day of a year just by providing the year?

For example, 2023.

I have =DATE(YEAR(B4);1;1) but it only works if I provide a date and not just the year.

Help Help

Thank you :)

2 answers

  1.
    The_boss_68 Posted messages 959 Registration date   Status Member Last intervention   182
     

    Hello,

    If I understood correctly!

    =DATE(A1,1,1)

    Cheers

    1
    1. nathan01983 Posted messages 30 Registration date   Status Member Last intervention   10
       

      Thank you, it's good

      0
  2. Pierr10 Posted messages 13831 Registration date   Status Moderator Last intervention   5 840
     

    Hello

    Enter the date in B3 in the format 01/01/2023

    If you only want to see the year, format the cell as yyyy (custom format).

    To find out the day of January 1st, type in the desired cell:

    =IFS(WEEKDAY(B3;2)=1;"Monday";WEEKDAY(B3;2)=2;"Tuesday";WEEKDAY(B3;2)=3;"Wednesday";WEEKDAY(B3;2)=4;"Thursday";WEEKDAY(B3;2)=5;"Friday";WEEKDAY(B3;2)=6;"Saturday";WEEKDAY(B3;2)=7;"Sunday")

    What one clearly conceives is clearly expressed,
    And the words to say it come easily.
    (Boileau)

    0