Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi everyone and thanks for any help you can give me. One of you guys always
comes upwith the answer I need. Anyhow, I am running XP Pro and Excel 2003. I have a workbook with twelve individual pages (one for each month). Each page has lines available for data entry for each day of the month. In cell B4 I manually enter the current year (i.e. 2008). On the first page (Jan) I want cell A6 to return 01/01/08 (I have the cell formatted for xx/xx/xx), cell A7 to return 01/02/08, etc. What formula would I use to accomplish this? I also need to do the same thing on each month's page, so how would the formula be different on the Feb page? Finally, on each page cell A45 is to always return the last day of that particular month. I'm hopng someone is a pretty good whiz at this and can fire back some help. Thanks again, Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date function in ACCRINTM requires date format not available | Excel Worksheet Functions | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |