charlesstricklin
Board Regular
- Joined
- May 6, 2013
- Messages
- 98
- Office Version
- 2021
- Platform
- Windows
I'm not able to calculate the date (accurately) I should run out of an item using the formula:
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #003ecc}span.s2 {color: #005109}</style>
[/FONT][/COLOR]
where the values in column N represent the number of days I have left for an item. I've been fumbling along with other date-related functions, but nothing works. What am I not seeing?
<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #003ecc}span.s2 {color: #005109}</style>
Code:
=TODAY()+N2[COLOR=#222222][FONT=Verdana]
[/FONT][/COLOR]
where the values in column N represent the number of days I have left for an item. I've been fumbling along with other date-related functions, but nothing works. What am I not seeing?