using Dates

[Tomo]

Hi I would like to use dates in a spreadsheet

for example if i was to renew a licence every year i wanted

a1 to show date of last licence
a2 to show ok if within the year if over 1 year 30 days reminder if over 1 year 60 days overdue

i have something like this in mind but how is the decimal number reached for working out how many days for a year

=IF(T7="Owner","OK",IF(T7="Not required","Not Required",IF(T7="Required","",IF(TODAY()-T7<1095,"OK",IF(TODAY()-T7<1065,"30 days",IF(TODAY()-T7<1035,"60 Days","Overdue"))))))

 

[Tomo]

Worked this one out cheers