Finding Number of Particular Days Problem in a Period

L

Les

Thankyou to those who answered this; your formula works, and it gives the right answer. However, this formula is activated from cells that get dates from a calendar. Whenever a date in the calendar is chosen, it gives a REF# answer, not a numerical answer as it should; but whenever you type the date in the cell, it works! Help - what do I need to change to get this formula to work from the calendar?
 
N

Nimit Mehta

You should have typed your entire question again. Most
people around like me will read your post and it wont be
answered because they dont know what you are looking for.
-Nimit
-----Original Message-----
Thankyou to those who answered this; your formula works,
Click to expand...
and it gives the right answer. However, this formula is
activated from cells that get dates from a calendar.
Whenever a date in the calendar is chosen, it gives a REF#
answer, not a numerical answer as it should; but whenever
you type the date in the cell, it works! Help - what do I
need to change to get this formula to work from the
calendar?
 
Top