dpaton05
Well-known Member
- Joined
- Aug 14, 2018
- Messages
- 2,352
- Office Version
- 365
- 2016
- Platform
- Windows
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?
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?
Excel Formula:
=IF(OR(WEEKDAY(DATE(G85,1,26))={7}, WEEKDAY(DATE(G85,1,26))={1}), “”, DATE(G85,1,26))
Last edited: