calculate days

A

ADIB

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
 
J

JBeaucaire

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change date format to 7 working days a week in ms project 2010? 0
Date Calculation - Astro Calculation 0
number of months and days between two dates without approximation 3
Conditional Format where ANY date is >= 30, 60, 90 days EXCEL 2007 1
calculate days 3
Formula within Pivot Table Calculated Field - Days in time period 0
End Date Calculation (adding a start date duration) 5
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1

Top