Function to display the Australia day date but if Australia day falls on a saturday or sunday for a year, display nothing

[dpaton05]

I have the year in G85.

I am trying to make write an excel function to display the date of Australia day for the year in G85 but if it falls on a saturday on sunday, I want to display nothing in G96, where the formula is.

Can someone show me what is wrong with my function please?

=IF(OR(WEEKDAY(DATE(G85,1,26))={7}, WEEKDAY(DATE(G85,1,26))={1}), “”, DATE(G85,1,26))

 

[dpaton05]

I worked it out, I think there was something wrong with the double inverted commas. I deleted them and typed them in again and it seemed to work.

 

[Dave Patton]

consider

Date and Time.xlsm
	A	B
1
2		Jan 26, 2021
3
18a

Cell Formulas
Range	Formula
B2	B2	=IF(WEEKDAY(DATE(G85,1,26),2)>5,"",DATE(G85,1,26))

 

[dpaton05]

What is the difference between your function and mine?

 

[Michael M]

It's shorter....

 

[dpaton05]

Thanks Michael.

 

[Dave Patton]

Thanks for the feedback.