Calender
Posted by Scott Heter on November 15, 2000 9:59 AM
I need Excel to be able to genrate a calender so I can
pick a day from any month & year and get the right date.
Am I asking too much?
Posted by marbel on November 15, 2000 10:41 AM
Not at all. Excel has a number of date features and should be able to do what you want... Can you be more specific about what you're trying to do? Or check out the help file for "date and time functions."
mb
Posted by Scott Heter on November 15, 2000 11:00 AM
Ok sure. I need know the date of the 3rd Friday of any
given month of any given year.
Posted by Ben O. on November 15, 2000 12:27 PM
Okay, we'll assume A1 is the year and A2 is the month.
=DATE(A1,A2,1) will give you the first day of the month for the year and month you enter. Enter that formula in A3.
=WEEKDAY(A3,1) will give you the day of the week of the first day of the month. Enter that formula in A4.
=IF(A4<7,6-A4,6) will give you the number of days between the first day of the month and the next Friday. Enter that formular in A5.
=A3+A5+14 will give you the date of the third Friday of the month and year you've entered. It adds the first day of the month (A3) with the number of days until the next Friday (A5), which will give you the date of the first Friday. Adding 14 (two weeks) gives you the date of the third Friday.
You can probably combine some of the formulas into one cell.
-VF
Posted by Scott Heter on November 16, 2000 6:51 AM
Ben,
WOW! Great work. This is exactly what I needed.
Your the man. 100,000 Thanks!
