Thread: calculate days
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default calculate days

Then in B1 put:

=if(a1+30<today(),"",a1+30)

Regards,
Fred.

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