Thread
:
Date function question
View Single Post
#
4
Vicar
Posts: n/a
Have you tried EDATE(A1,-12)?
"John Day" wrote:
I have a date in cell A1. I would like the date in
cell B1 to reflect the prior year date base on cell A1.
The results in cell B1 should consider leap year. How do I
do this?
Thanks,
John
Reply With Quote