Finding Number of Particular Days Problem in a Period

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

Guest

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?
 
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?
 

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

Finding Number of Particular Dayns Problem in a Period 3
Testing a cell value for a specific weekday. 3
Calculate next workday after adding calendar days to date in cell 13
display first or second match instead of #REF in INDEX ROW formula 9
Calculating number of periods 2
Formula to get number of days excluding Fridays in a given period 17
COUNTIFS ? 1
Finding number of particular days in a period 3

Back
Top