Thread: Calculating as per the number of days in a month
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Liang Liang is offline
external usenet poster
  
Posts: 1
Default Calculating as per the number of days in a month
Set two date value, one is for today, the other one is the end of year date.
And then use the end of year date minus today's date. You'll get the days.

Date
1/1/2008
6/1/2007
Formula Description (Result)
=A2-TODAY() Number of days from current date to end of 2007 (Varies)
=A2-A3 Number of days from 6/1/2007 until the end of 2007 (214)



Reply With QuoteReply With Quote