help with countdown clock formula

[buddy1]

boss is on my back about creating a formula that will take a date and countdown from a month (date-30days). this needs to be a running clock, something that the status can be checked every day. i have never had to do something like this before and am in panic mode. can anyone help??

 

[gaz_chops]

Explain, what date do you want as the start date?

 

[buddy1]

Explain, what date do you want as the start date?

ok, sorry. what we are doing is looking for scaffolds that are up for inspection. we will enter the date that it was inspected and 30 days from that inspection date we will need to do it again. we have over 1700 scaffolds up now. what we are looking for is a countdown formula that will take that inspection date and count down from 30 days, when it hits 0 we will know its up for another inspection. thank you for showing interest.

 

[gaz_chops]

Something like - change ref A1 to cell containing date
=IF((A1+30)-NOW()<=0,"Overdue",(A1+30)-NOW())

Format cell with this formula as dd:hh:mm.

Note you will need to refresh sheet to update time left.

 

[gaz_chops]

Maybe overkill! No need to format cell -
=IF((A1+30)-NOW()<=0,TEXT(NOW()-(A1+30),0)&" Days Overdue","Due in "&TEXT((A1+30)-NOW(),"dd")&" Days")

 

[buddy1]

that worked beautifuly!! thank you so much for your help!

 

[gaz_chops]

You're welcome, did you go with 1st or 2nd option? Just curious

 

[OriginalCarey]

Maybe overkill! No need to format cell -
=IF((A1+30)-NOW()<=0,TEXT(NOW()-(A1+30),0)&" Days Overdue","Due in "&TEXT((A1+30)-NOW(),"dd")&" Days")

Crikey!

 

[gaz_chops]

Crikey!

LOL, well it's how I would do it