Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date function question
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 |
#2
|
|||
|
|||
Hi John
check out the DateDif function at Chip Pearson's website ... there's a discussion on how it works with leap years at the bottom of the page http://www.cpearson.com/excel/datedif.htm Cheers JulieD "John Day" wrote in message ... 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 |
#3
|
|||
|
|||
Have you tried =A1-365 ?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "John Day" wrote in message ... 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 |
#4
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
IF Function with Date revised question | Excel Worksheet Functions | |||
Formula for date function | Excel Worksheet Functions | |||
Another date function question | Excel Worksheet Functions | |||
Another date function question | Excel Worksheet Functions |