Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
column C has a date in it. Column D has a date 90 days from column C .I want column E to show the word "throw" when the date in D is older than the actual day it is. its only "D" I need help with. Can you help me ?
Not sure exactly where you're going wrong but
Column D = C1+90
etc etc
Column E = if(d1>today(),"Throw","")
what he said...
=IF(C1+90<=D1,"throw","blank")
i think thats what you mean, but play with it
copied/pasted but that dont seem to work
Most systems (Excel included) use a date format where 1 = 1 day, less than that is a decimal. The date systems start from either 01/01/1900 or 01/01/1904.
To see the date time serial number just reformat the cell to general, i.e. enter 16/09/09 19:05 (Excel automatically formats the cell using a date / time format) and then format the cell using general format and the value will be 40072.79514.
Column C - Column D - Column E - Excel function
17/09/2009 - 16/12/2009 - throw - =IF(C1>TODAY(),"Throw","Example")
10/06/2009 - 08/09/2009 - Example
Bit of a bugger to get the columns lined up
its too late for me to try that tonight now, i'll try tomorrow. Failing that can I email you the spread sheet ?
I'll check back tomorrow. Off to bed now - up again in 6.5hrs.