Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 9

if cell is blank then calculate how many days?

What would the formula in C column be if I want to know how many days from
the A column date to today - if the B column is blank?

A B C
Start Date Return to Work Date Out How Many Days?
06/29/2009
01/11/2009 02/02/2009

Thank you for your help!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How to calculate # of days	Jonathan	Excel Worksheet Functions	3	March 4th 09 09:23 PM
Calculate the Days	migdad	Excel Worksheet Functions	8	May 1st 06 12:53 AM
Formula to calculate number of days & ignore blank cells	Mifty	Excel Discussion (Misc queries)	7	February 13th 06 10:36 PM
formula to calculate future date from date in cell plus days	Chicesq	Excel Worksheet Functions	8	November 3rd 05 12:25 PM
if blank cell, don't calculate	Dan	Excel Worksheet Functions	2	June 13th 05 06:11 PM

All times are GMT +1. The time now is 06:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us