LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
KCi KCi is offline
external usenet poster
 
Posts: 7
Default Match Last day of this month to last day of last month

Hi All, I have a question that I have not been able to answer on my own.
I have to compare calendar days in this month vs prior month, but I need the
last days to line up (so essentially, start in reverse) so month a will have
30 days and month b will have 31 days I need for month b to start on day two
as the comparison. The days (and values) of the two months increment each day
for the current month, prior month is established and filled.

If this is not clear (which I am sure it's not) let me know,
any help would be much appreciated...
 
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
12 Month Average Dewayne Excel Worksheet Functions 10 November 6th 06 09:18 PM
How do I enter variable data into a formula Iain Mac Excel Discussion (Misc queries) 4 October 30th 06 05:27 PM
How to create a rolling 6 month average? anley Excel Discussion (Misc queries) 3 August 14th 06 12:41 PM
Working days left in the month compared to previous months qwopzxnm Excel Worksheet Functions 8 October 24th 05 08:00 PM
HELP with this function Jay Excel Worksheet Functions 7 May 24th 05 06:45 PM


All times are GMT +1. The time now is 08:00 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"