LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rhonda1
 
Posts: n/a
Default FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES

I have two questions. I have three columns that will have a calendar date in
them. On the fourth column, I need to put in a formula that will count the
days of the previous three columns. I can't seem to find the function that
will do this for me.

Second question I need a formula that will calculate the hours it took to
complete the tasks. i.e. convert the number of days into hours.

Also, one more...is there a way that once data is placed into one
cell....the cell in the column on the right will automatically configure the
current date?

Thanks!
Rhonda
 
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
Excel Count Formula? Mrebisz3154 Excel Worksheet Functions 2 January 18th 06 05:15 PM
Excel formula help needed SteveFox Excel Worksheet Functions 2 November 23rd 05 12:52 AM
formula needed to track dates event happened ilmeaz Excel Worksheet Functions 1 November 15th 05 02:52 AM
to find number of days between 2 dates using vba code in excel sjayar Excel Discussion (Misc queries) 3 November 3rd 05 06:24 AM
how would I count dates (not # of days) in cells that fall betwee. sailingscotts Excel Worksheet Functions 3 August 16th 05 04:29 AM


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