Formula's for calculating 1) year 2)month and 3)weeknum for when date is blank

[brian_2me]

Hi,

I have the following 3 formulas
=TEXT(A4,"YYYY")
=TEXT(A4,"MMM")
=WEEKNUM(A4)

I would like to modify these formulas so that where if A4 is blank the formula to returns a blank cell rather than 1900 for year or Jan for month

Thanks.

[Jonmo1]

Try

=IF(A4="","",TEXT(A4,"YYYY"))

[daddylonglegs]

For the TEXT functions you could also use this approach

=TEXT(A4,"YYYY;;")