answersLogoWhite

0

=IF(G17="","No Audit on File",(IF(G17>TODAY(),"Valid","Expired")))

Works!!

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you add date stamp on excel?

Try this formula: =NOW() If you don't want the time, the formula is =TODAY()


Can you use expired baby formula?

no, it can harm the child you feed it to. =] Premixed formula: No, definitely not, this could definitely be harmful. Dry powdered formula: The "best if used" is just that, the date the formula is best used by. From that date on, the chemicals start breaking down and the formula starts losing its nutritional value. It's up to you if that's acceptable. Expired powdered formula is very unlikely to be actually be harmful, though.


What happens when Excel assigns a formula value to the date?

This question is not clear. You can use dates in a formula, but you can not assign a formula value to a date. If you are trying to use dates in formulas, use them like you would any other number. If A1 contains a date, you can show the date six days earlier by using the formula =A1-6.


Last date of vat audit in up?

last date of vat audit in up for the f. y. 2010-11


Do Happy Child disper have expired date?

Yes. Happy Child disper usually have an expired date.


What is the shortcut to enter the date in Excel?

The formula is =NOW(). Ensure you format the cell to display the date format you want.


How can I determine if a check is expired?

To determine if a check is expired, check the date written on the check. If the date has passed, the check is considered expired and may not be accepted by the bank.


If you have an excel template with automatic date you want that the saved document dont change the date only the template do is there a formula?

I you have a worksheet that updates the date in a cell to the current date, edit the cell to change to the date you want displayed. Most likely, the cell is using the formula =NOW() or some other date function to automatically assign a date to the worksheet. When you replace the formula with the date you want to display, your date will remain until you change it.


Which symbol may be used in an Excel formula to display current date?

The TODAY() function displays the current date. If you want to put the current date into a cell, press the Ctrl and the semi-colon key.


Has the sea moss gel expired?

To determine if sea moss gel has expired, check the expiration date on the packaging. If the expiration date has passed, it is likely expired and should not be consumed.


How do you format a cell in micro soft excel to automatically update the day month and year every time it opens?

Type this formula in the cell (including the 'equals' signand the empty parentheses):=TODAY()Then, make sure the date in your computer is correct.That's the only way Excel knows the date.


How do you read the Best Before date?

By reading the expired date and you will known