[FREE EBOOK PDF DOWNLOAD]EXPIRY DATE REMINDER: (Using Excel Formula) by SUSANTA CHOUDHURY - KING OF EXCEL

# [FREE EBOOK PDF DOWNLOAD]EXPIRY DATE REMINDER: (Using Excel Formula) by SUSANTA CHOUDHURY

Author:SUSANTA CHOUDHURY [CHOUDHURY, SUSANTA]
Language: eng
Format: azw3
Published: 2017-10-08T04:00:00+00:00

To get today date use this formula
= ( use “=” in a cell where you want to get the result.)
=TODAY
=TODAY()
ENTER
Based on the result of remaining days we will find out final report of expiry days.
To get the “NO OF DAYS REMAIN”
=EXPIRY DATE - TODAY
=D5-F5
to get the “expiry status”
we shall use “IF” Formula and there are two condition we shall use. one condition is “if the reaming days is less then 0 day (<0) then one will display in the cell is “Expired”, if the remaining days is less then 15 (<15) then one massage will display “expiring soon”.
Here “G5” cell means “Remaining Days” So select “Remaining Days” to calculate “EXPIRY STATUS” Directly write the formula below mentioned in destination cell ( H5 ) to get the STATUS.
=IF(G5<0,“EXPIRED”,IF(G5<15,”EXPIRING SOON”,””))
or if you are new using the formula then use the formula very carefully one by one step
=
=IF
=IF(
=IF(G5
=IF(G5<0,
=IF(G5<0,“EXPIRED”
=IF(G5<0,“EXPIRED”,
=IF(G5<0,“EXPIRED”,IF
=IF(G5<0,“EXPIRED”,IF(
=IF(G5<0,“EXPIRED”,IF(G5
=IF(G5<0,“EXPIRED”,IF(G5<15,
=IF(G5<0,“EXPIRED”,IF(G5<15,”EXPIRING SOON”
=IF(G5<0,“EXPIRED”,IF(G5<15,”EXPIRING SOON”)
=IF(G5<0,“EXPIRED”,IF(G5<15,”EXPIRING SOON”,””))
#evba #etipfree #eama #kingexcel