Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Counting Days

Hello -

I'm trying to figure out a formula that tells me the number of days until a
date or tells me how many days have passed since the date.

Meaning, if today is 01/01/10 and my target date is 01/05/10, I would like
the formula to return "-5".

If today is 01/10/10 and my target date was 01/05/10, I would like the
formula to return "5".

Any help would greatly be appreciated.

Thanks for your time.
 
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
Counting no of days of a specific range of days from a list Manikandan[_2_] Excel Discussion (Misc queries) 10 December 24th 09 12:26 PM
Counting Days Belinda7237 Excel Worksheet Functions 2 June 16th 08 06:01 PM
counting days belvy123 Excel Discussion (Misc queries) 2 March 23rd 07 07:14 AM
counting days? Richard Excel Discussion (Misc queries) 2 August 1st 06 02:37 PM
counting days Anthony Excel Discussion (Misc queries) 4 February 3rd 05 09:08 PM


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