Thread: Counting Days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DyingIsis DyingIsis is offline
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.