rrtts
12-07-2006, 02:47 PM
I use the following formula to provide the Julian Date:
=TODAY()-DATE(YEAR(TODAY()),1,0)
So, for today...it results in 341.
I'm trying to modify it to show 341 / 342.
I tried doing this...
=TODAY()-DATE(YEAR(TODAY()),1,0) & " / " & TODAY()-DATE(YEAR(TODAY()),1,0)+1
Which gives me 341 / 342 but it replaces the formula in the cell with these values...I want the formula to remain so it will update whenever I open the sheet.
I'm sure I'm doing something wrong...anybody have an idea?
=TODAY()-DATE(YEAR(TODAY()),1,0)
So, for today...it results in 341.
I'm trying to modify it to show 341 / 342.
I tried doing this...
=TODAY()-DATE(YEAR(TODAY()),1,0) & " / " & TODAY()-DATE(YEAR(TODAY()),1,0)+1
Which gives me 341 / 342 but it replaces the formula in the cell with these values...I want the formula to remain so it will update whenever I open the sheet.
I'm sure I'm doing something wrong...anybody have an idea?