Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default In a range of months can I capture the most current month entry?

Are the months full dates? And what defines most recent month, the one that
today is in, the date above not later than today?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Karlene" wrote in message
...
I have a spreadsheet with months accross the top. In my total column I
want
to capture the number in the most recent month.



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
Subtract a future month from the current month to get remaining m. Fletch Excel Worksheet Functions 1 July 26th 07 04:29 PM
Retrieve data for previous 3, 6, 12 month given current month GB Excel Worksheet Functions 4 July 19th 07 11:58 PM
Highest 12-Month Period Average Over Range of Months Mark T. Excel Worksheet Functions 8 January 24th 07 03:55 AM
Graphing past months (totals) and current month (weekly total) in Davin Charts and Charting in Excel 1 July 27th 05 05:01 PM


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