![]() |
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. |
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