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