ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I use the IF formula to flag me 21 days after the date? (https://www.excelbanter.com/excel-worksheet-functions/111547-how-do-i-use-if-formula-flag-me-21-days-after-date.html)

Wanderer

How do I use the IF formula to flag me 21 days after the date?
 
I need to set up a spreadsheet that will flag me when it is 21 days past the
date I input originally.

pdberger

How do I use the IF formula to flag me 21 days after the date?
 
Wanderer --

Howze about:

A
1 Date
2 =IF(TODAY()-A121,"Holy cow!","")

Should do the trick. HTH

"Wanderer" wrote:

I need to set up a spreadsheet that will flag me when it is 21 days past the
date I input originally.



All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com