Hi everyone,
Basically I have a list of dates. I have used
=CELL-TODAY()
and then making the cells General format to show the number of days till that date. However I was getting negative days - I didn't really want this, I wanted simply 0 - to show that it was already released (the data pertains to release dates). I then used this:
General;"0"
This works fine. I then wanted a weeks column, so I divided the days column by 7. Again, this works but some have a large amount of decimal places.
Is there any way to do the following:
Get fields showing a "0" to display text such as "Now available", and get the Weeks column to show something like "xx Weeks xx Days"?
Thanks for any help
Basically I have a list of dates. I have used
=CELL-TODAY()
and then making the cells General format to show the number of days till that date. However I was getting negative days - I didn't really want this, I wanted simply 0 - to show that it was already released (the data pertains to release dates). I then used this:
General;"0"
This works fine. I then wanted a weeks column, so I divided the days column by 7. Again, this works but some have a large amount of decimal places.
Is there any way to do the following:
Get fields showing a "0" to display text such as "Now available", and get the Weeks column to show something like "xx Weeks xx Days"?
Thanks for any help