DocHub is an all-in-one PDF editor that enables you to darken flag in excel, and much more. You can underline, blackout, or erase document components, insert text and images where you need them, and collect data and signatures. And since it runs on any web browser, you won’t need to update your device to access its powerful features, saving you money. With DocHub, a web browser is all it takes to handle your excel.
Sign in to our service and follow these guidelines:
It couldn't be easier! Enhance your document management today with DocHub!
Hey welcome back to the MrExcel netcast, Iamp;#39;m Bill Jelen. Today we got a nice email from Van, Van was talking about podcast number 539 where I showed a formula that basically took someoneamp;#39;s birthday and converted it to this year, the situation there was someone was trying to send birthday cards out to their customer base they were looking for the customers that had birthdays next five to seven days or something like that. Van said; you know heamp;#39;d be a great idea if you took that one step further and actually red flag the customers who were five to eight days away that weamp;#39;d be able to do it very quickly so I built a formula here in column D that says basically weamp;#39;re going to take the date in C2, equals C2, minus the today function =C2-TODAY(), the today function is going to give us todayamp;#39;s date, if the birthdays already passed thatamp;#39;s going to be a negative number weamp;#39;ll just keep that in mind, and what Iamp;#39;m going to do