View original (French)

How to calculate the first day of a year using a formula

Solved
iskmali Posted messages 108 Status Member -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

How can I obtain the first day of a year from any given date using a formula?

For example, if I have the date 10/11/2017, the formula should return 01/01/2017.

Thank you in advance for your help.

Thanks

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Good evening
    with a date in A1

    =DATE(Year(A1),1,1)

    best regards

    --
    The quality of the response mainly depends on the clarity of the question, thank you!
    0
    1. iskmali Posted messages 108 Status Member 1
       
      Thank you very much Vaucluse, it's perfect.
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      No problem!!
      I'm marking the topic as resolved
      Safe travels
      Best regards
      0