View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Extract a date for formula

Isn't one singular?

Isn't the day of the month, the number of days since the start?

--
Regards,
Tom Ogilvy



"jsc3489" wrote in message
...
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!