vendredi 28 juillet 2017

day formula in a if statement

I am using the formula below to check to see if January first is on Saturday. The calendar I've created will flip years using a macro in place, so January first may not always lay on a Saturday. The reason I need to use DAY is because the cell it is refering to is in a DAY format.

=IF(DAY(H5)=1,"Winter","") Formula

January 1st Days of the week

2018- Monday Calendar

2019- Tuesday

2023- Saturday etc...

So H5 is the place of the first Saturday in January,

if H5 = January 1st it should show "Winter" if not it should return blank. The issue is the formula is getting caught on the DAY(H5)=1. It returns #Value instead of a blank. Is there a work around I can use to show blanks instead?

I have conditional formatting in place so the cell is grayed out (Font colour and Fill). It looks good when it's in the spreadsheet but once it it is printed it will still show #VALUE.

Thanks in advance,

Aucun commentaire:

Enregistrer un commentaire