LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JCO JCO is offline
external usenet poster
 
Posts: 54
Default Macro for Dates

I have a report that requires the current date in the right header and the
date range in left header. The date range is the first day of the previous
month to the last day of the previous month.

Example: Today is 11/05/2013. As I run the macro, it should look like
below:
Date Range: 10/01/2013 - 10/31/2013 Date:
11/05/2013

Thanks

 
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
Macro to Check Dates Beep Beep Excel Programming 1 March 15th 10 05:31 PM
Macro or formula for dates cmatera Excel Worksheet Functions 1 September 4th 08 07:44 PM
Macro to identify bad dates Sandeman[_13_] Excel Programming 3 March 23rd 06 02:34 PM
too many dates macro nastech Excel Discussion (Misc queries) 2 January 21st 06 08:37 PM
Macro changes the format of dates Rodolfo Silva Excel Programming 4 August 29th 03 05:12 AM


All times are GMT +1. The time now is 01:40 PM.

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"