Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default argument box for date/time function

I need to do funcions using my own data right now i need to know how to enter
data in the function argument box for date/time function days 360. ie start
date, end date, method. co
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,344
Default argument box for date/time function

Hi,

Put your cursor in the cell where you want the formula and click the Fx
button on the Formula Bar or press Shift+F3, choose Date & Time from the
Select a category box, double-click DAYS360. In the Function Arguments box
enter any legal Excel date such as 1/1/2008, in the Start_date box. Enter
any legal date in the End_date box, for example 12/31/2008. In the Method
box enter TRUE or FALSE depending on whether you are using US or European
method for the calculation. Click the Help on this function link at the
bottom left of the dialog box if you want more info.


--
Thanks,
Shane Devenshire


"cotley" wrote:

I need to do funcions using my own data right now i need to know how to enter
data in the function argument box for date/time function days 360. ie start
date, end date, method. co

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
VLOOKUP with date as an argument Gilbert De Ceulaer[_2_] Excel Worksheet Functions 2 January 3rd 08 04:55 PM
VLOOKUP with date as an argument Gilbert De Ceulaer[_2_] Excel Worksheet Functions 0 January 3rd 08 12:02 PM
Run-time Error '5' - Invalid procedure call or argument Trefor Excel Discussion (Misc queries) 2 December 17th 07 03:32 AM
Need Function Argument pasekm Excel Worksheet Functions 4 March 18th 06 11:14 PM
Run-time error '5': Invalid Procedure Call or Argument Nikila Excel Discussion (Misc queries) 2 February 24th 06 09:26 PM


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