Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 16-jul-07 date format to sum at quarters see example

16-Jul-07 FY07/Q1 FY07/Q2

$0 $0
I want the input of the date 16-Jul-07 to sum or be populated at the end of
my spread sheet the calendar.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default 16-jul-07 date format to sum at quarters see example

That is totally incomprehensible to me, sorry I don't understand what you
want to do


--


Regards,


Peo Sjoblom



"Lanette" wrote in message
...
16-Jul-07 FY07/Q1 FY07/Q2

$0 $0
I want the input of the date 16-Jul-07 to sum or be populated at the end
of
my spread sheet the calendar.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 16-jul-07 date format to sum at quarters see example



"Peo Sjoblom" wrote:

That is totally incomprehensible to me, sorry I don't understand what you
want to do


-- Between the date 16-jul-07 and the "Quarter" totals are expenses. I want to be able to change the 16-jul-07 date and for the "Quarter" totals to be populated with the summing the expenses. From under the cell titled "Quarter" what would I have to do.


I know that I have to sum the expenses.


Regards,


Peo Sjoblom



"Lanette" wrote in message
...
16-Jul-07 FY07/Q1 FY07/Q2

$0 $0
I want the input of the date 16-Jul-07 to sum or be populated at the end
of
my spread sheet the calendar.




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
Forward & Backwards Quarters from an Entered Date Danny Excel Worksheet Functions 2 June 21st 07 08:07 PM
Convert date + time text format to date format Paul Ho Excel Worksheet Functions 2 May 22nd 07 05:47 PM
Date To Quarter, Plus Next 3 Quarters Bob Excel Worksheet Functions 1 November 3rd 06 01:25 PM
How do I calculate the number of quarters between two date Adam Excel Discussion (Misc queries) 1 September 1st 05 11:02 AM
Excel 2000 date format cannot be set to Australian date format Brian Jones Excel Discussion (Misc queries) 1 March 30th 05 06:03 AM


All times are GMT +1. The time now is 02:13 PM.

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"