| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Like the DAYS360, Datev& Time Function is there one for 365 day ?
On the formula how do have it calculate based on 365 days ??
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Like the DAYS360, Datev& Time Function is there one for 365 day ?
Hi Luis
With start date in A1 and end date in B1 just =B1-A1 will give the number of days between the two dates. -- Regards Roger Govier "Luis" wrote in message ... On the formula how do have it calculate based on 365 days ?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Like the DAYS360, Datev& Time Function is there one for 365 da
Hi Roger,
The formula i.e. is DAYS360 (RANGE HIRE DATE. TO DATE)is part of a vacation recording, however I would like to calculate it based at 365 days, instead of the 360 as in the function. Thanks, Luis "Roger Govier" wrote: Hi Luis With start date in A1 and end date in B1 just =B1-A1 will give the number of days between the two dates. -- Regards Roger Govier "Luis" wrote in message ... On the formula how do have it calculate based on 365 days ?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Like the DAYS360, Datev& Time Function is there one for 365 da
Hi Luis
Yes, I understand that, but if you change the order and use (TO DATE - HIRE DATE) that will calculate the interval for you based upon 365 (or 366 in leap year) days. With Hire date of 01 Jan 2005 and to date being 16 Sep 2006, the formula =DAYS360(Hire date,To date) produces a result of 615 =(To Date-Hire date) produces a result of 623 You need to format the cell with the formula as FormatCellsNumberGeneral otherwise you will see a result of 14/09/1901 (being 623 days after 01/01/1901) -- Regards Roger Govier "Luis" wrote in message ... Hi Roger, The formula i.e. is DAYS360 (RANGE HIRE DATE. TO DATE)is part of a vacation recording, however I would like to calculate it based at 365 days, instead of the 360 as in the function. Thanks, Luis "Roger Govier" wrote: Hi Luis With start date in A1 and end date in B1 just =B1-A1 will give the number of days between the two dates. -- Regards Roger Govier "Luis" wrote in message ... On the formula how do have it calculate based on 365 days ?? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Like the DAYS360, Datev& Time Function is there one for 365 da
Thanks Roger
"Roger Govier" wrote: Hi Luis Yes, I understand that, but if you change the order and use (TO DATE - HIRE DATE) that will calculate the interval for you based upon 365 (or 366 in leap year) days. With Hire date of 01 Jan 2005 and to date being 16 Sep 2006, the formula =DAYS360(Hire date,To date) produces a result of 615 =(To Date-Hire date) produces a result of 623 You need to format the cell with the formula as FormatCellsNumberGeneral otherwise you will see a result of 14/09/1901 (being 623 days after 01/01/1901) -- Regards Roger Govier "Luis" wrote in message ... Hi Roger, The formula i.e. is DAYS360 (RANGE HIRE DATE. TO DATE)is part of a vacation recording, however I would like to calculate it based at 365 days, instead of the 360 as in the function. Thanks, Luis "Roger Govier" wrote: Hi Luis With start date in A1 and end date in B1 just =B1-A1 will give the number of days between the two dates. -- Regards Roger Govier "Luis" wrote in message ... On the formula how do have it calculate based on 365 days ?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Count function applied to a time period | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| DAYS360 function for 365 day year | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Linear Mode
