Thread: calculate days
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JBeaucaire[_90_] JBeaucaire[_90_] is offline
external usenet poster
 
Posts: 222
Default calculate days

Every time you open your sheet, the value of TODAY() gets update
to...well....today! As such, it is not appropriate to use for any kind of
timer.

You will have to insert an actual date somewhere on your sheet for the 30
day timer to start. You can have B1 set to show anything you want, but use
conditional formatting to suppress being able to SEE what is in that cell
until after that date has + 30 days has passed. Would that work for you?

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"ADIB" wrote:

What do you mean? You want to add 30 days to A1, or you want that date to
appear after 30 days?
Hi Bob
i don't want to add 30 days i need in b1 appear date after complition of 30
days from today.i dont want the date appear before 30 days or calculate by
adding 30 days.can it possible please help me
Thanks