View original (French)

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

Solved
iskmali Posted messages 108 Status Membre -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
iskmali Posted messages 108 Status Membre 1
 
Thank you very much Vaucluse, it's perfect.
0
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
No problem!!
I'm marking the topic as resolved
Safe travels
Best regards
0