Hi again,
No sonner do I sort one problem, i'm hit again with another.......
I have now been given the formula to help me with looking at a cell that contains a date [i.e. 06/02/2012] and returning the number of days in that month. [29]
Is there a forumla whereby in cell A1 if have the same date 06/02/2012 the formula this time in cell A3 returns the number of weekdays only in that given month [Mon-Fri], so the answer would be 21 for Feb-2012.
Sorry if these are basic questions.
Many Thanks
PW
Bookmarks