Date + 365 in New Column

H

Harlan Grove

Sandy Mann said:
Congratulations! it works for all dates.

I knew you could do it if I pushed you <g>
Click to expand...
....

I deserve that this time. Figures I'd come up with the simple approach now
that I finally managed to get the complex approach working.

=F2+366-(DAY(F$2)<>DAY(F2+366)) [for filling down]
=F2+366-(DAY($F2)<>DAY(F2+366)) [for filling right]

So why didn't you think of that before me?
 
S

Sandy Mann

Harlan Grove said:
So why didn't you think of that before me?
Click to expand...

Harlan you're not developing a sense of humour are you? <g>
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top