| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if cell is blank then calculate how many days?
=IF(B2="",TODAY()-A2,"")
If you want to limit this to workdays (Mon-Fri) try: =IF(B2="",NETWORKDAYS(A2,TODAY())-1,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Machel" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if cell is blank then calculate how many days?
Try this:
=IF(AND(COUNT(A1),B1=""),TODAY()-A1,"") -- Biff Microsoft Excel MVP "Machel" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if cell is blank then calculate how many days?
Thank you so much! that worked!
If we also want to know the number counting all the days (not just work days), then I would remove the NETWORKDAYS portion? "Luke M" wrote: =IF(B2="",TODAY()-A2,"") If you want to limit this to workdays (Mon-Fri) try: =IF(B2="",NETWORKDAYS(A2,TODAY())-1,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Machel" wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if cell is blank then calculate how many days?
Hi,
Here is another way to write it: =IF(B2,"",TODAY()-A2) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Machel" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate # of days | Excel Worksheet Functions | |||
| Calculate the Days | Excel Worksheet Functions | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
| formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
| if blank cell, don't calculate | Excel Worksheet Functions | |||
Linear Mode
