Hello,
I am looking to combine the following two formulae into one..
=DATE(YEAR(A1),MONTH(A1),1) 'This yields date - 10/1/2009
=WEEKDAY(B1)'This gives me an integer - 5
But I cannot figure out how to combine the logic into one formula.
Any help is greatly appreciated.
-Mick
I am looking to combine the following two formulae into one..
=DATE(YEAR(A1),MONTH(A1),1) 'This yields date - 10/1/2009
=WEEKDAY(B1)'This gives me an integer - 5
But I cannot figure out how to combine the logic into one formula.
Any help is greatly appreciated.
-Mick