Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Calculate the ISO Start of Year Date

No comments
Here is a formula to calculate the ISO Start of Year date for any legal Excel date. (Credit to Shane Devenshire for this excel formula)

=("1/4/"&YEAR(A1))-MOD("1/2/"&YEAR(A1),7)


This assumes that A1 is a valid date. With this formula you enter any date in a year and Excel returns the ISO Start of Year date. For example if you enter 9/11/09 in B2 the result of this formula is 12/29/08.

No comments :

Post a Comment