#1   Report Post  
 
Posts: n/a
Default Excel date changes

I have created a spreadsheet using excel which requires the use dates
on a monthly basis (similar to a calendar). The problem I have is that
every month I have to go in and change the dates on the spreadsheet to
reflect those of the current month before printing. Is there a way I
can make it so that excel does that for me every month.

Thanks, I'd really appreciate the input.

  #2   Report Post  
Jonathan Cooper
 
Posts: n/a
Default

Please elaborate on what the spreadsheet looks like.

" wrote:

I have created a spreadsheet using excel which requires the use dates
on a monthly basis (similar to a calendar). The problem I have is that
every month I have to go in and change the dates on the spreadsheet to
reflect those of the current month before printing. Is there a way I
can make it so that excel does that for me every month.

Thanks, I'd really appreciate the input.


Reply
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
How do I convert a number formated as a date to text in Excel? BrotherNov Excel Discussion (Misc queries) 5 March 2nd 05 03:51 PM
How do I insert the date the file was saved in the MS Excel foote. kacate Excel Discussion (Misc queries) 2 January 31st 05 09:11 PM
Excel formula with date constraints Warrior Pope Excel Discussion (Misc queries) 3 January 28th 05 03:08 PM
In Excel 2003, entering date without slashes, the date is incorre. sj Excel Discussion (Misc queries) 6 January 6th 05 03:07 PM
Excel 2002 date formulas problem Andrew Warren Excel Worksheet Functions 4 January 6th 05 11:35 AM


All times are GMT +1. The time now is 02:53 AM.

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

About Us

"It's about Microsoft Excel"