#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 96
Default service date

If I have a hire date of August 1985 and today's date is April 30th, how do
you create a formula that will give me a continuous service date?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default service date

Have a look at Chip's use of DATEDIFF (www.cpearson.com)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Pammy" wrote in message
...
If I have a hire date of August 1985 and today's date is April 30th, how
do
you create a formula that will give me a continuous service date?



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
New Service in Finland QQQ Excel Worksheet Functions 0 October 23rd 07 05:30 PM
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? Divya Sanam Excel Discussion (Misc queries) 0 July 20th 06 05:15 PM
How to estimate a future service date? Monkey.wrench Excel Worksheet Functions 1 January 13th 06 09:37 PM
SERVICE PACK 2 GILBERT Excel Worksheet Functions 2 June 25th 05 04:27 PM
Show only latest Date of Service? Woodkat Excel Worksheet Functions 7 December 10th 04 12:47 AM


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