Bolean date
Posted by edwin on August 08, 2001 9:43 AM
How can I get a Bolean date in a spreadsheet ?
I.e. today is day 222, (Aug 08)
Posted by Barrie Davidson on August 08, 2001 9:50 AM
Assuming your date is in cell A1, try
=A1-DATE(2000,12,31)
Barrie
Posted by Ian on August 08, 2001 2:00 PM
Also try
=A1-DATE(YEAR(A1)-1,12,31)
will allow you to enter any year, last/next etc.
Ian
