LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 19
Default Date function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date function in ACCRINTM requires date format not available Pev Excel Worksheet Functions 4 October 13th 07 12:20 PM
MAX figure within a date range as a function of today()'s date irvine79 Excel Worksheet Functions 6 February 20th 07 03:28 PM
SUMIF within date range as a function of today()'s date irvine79 Excel Worksheet Functions 8 August 6th 06 05:55 PM
Date Function formula that will return the date of a specific week Greg Excel Worksheet Functions 4 June 12th 06 05:07 PM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 07:18 PM


All times are GMT +1. The time now is 09:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"