View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default Extract a date for formula

If the date you are using is in cell A1, use this formula in H10:
=DAY(A1)
--
- K Dales


"jsc3489" wrote:

If I have a REFERENCE date, say 5/12/05 and I need to subtract the number of
days from the beginning of the month so that cell H10 holds the number 12
that I can use in another formula.
--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!