Determine number of days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a chart, column G and L represent the entry and exit dates with the total
weeks of enrololment (difference) reflected in column S. I used the formula
=(L-G)/7 in column S. That determines the difference when columns G and L
contain dates. If G and L are empty cells, I get the VALVE error message.
How do I revise the formula to reflect a zero when column G and/or L do not
contain a date? Many thanks for the help.
 
Probably L and/or G is not empty; it may contain a space.
If they're empty, your formula will result in zero.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to revise formula 2
Sumproduct problems... 4
Calculating the Count of Monthly Gains/Losses 3
fix #N/A error 4
a second call for the goddezzez and godz of SUMPRODUCT 2
Excel display two dates in one cell - excel 2010 2
Using Left/Mid functions to format download 2
take the green pill or take the SUMPRODUCT? 3

Back
Top