Days of month display
Would appreciate help with the following;
Upon entering a date (month-year) in a cell i.e. MMM-YY, I require a one column listing of the total days in that month and another column displaying which day of the week relates to the number column in the DDD format. Any ideas?
Last edited by carl; 01-01-2005 at 12:43 PM. Reason: Unclear
The following function will give you the number of days in the month (date is in cell C3 in this example):
=+DAY(DATE(YEAR(C3), MONTH(C3)+1, DAY(1))-1)
If it's not obvious, what this does is first set the date equal to the first day of "next month", then subtracts one day, then returns what day that is.
The following function will give you text for weekdays (again, the date is in cell C3)
=+CHOOSE(WEEKDAY(C3,1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
- Pete
Try this formula in teh cells
=DATE(YEAR(B3),MONTH(B3),DAY(0))
Last edited by Chandrajit; 02-06-2012 at 09:48 AM. Reason: missed the formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks