| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determine year over year date for comparison
Hello, I am trying to determine the date of the same Monday last year based
on the date of the latest Monday's date. If I just subtract 364 from the current date, I can get the date; however, I think that this formula would create errors if there is a leap year. Thank you, Brian |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Determine year over year date for comparison
Hi,
Try this =IF(WEEKDAY(A1-364)=2,A1-364,A1-365) Mike "zeroscou" wrote: Hello, I am trying to determine the date of the same Monday last year based on the date of the latest Monday's date. If I just subtract 364 from the current date, I can get the date; however, I think that this formula would create errors if there is a leap year. Thank you, Brian |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Determine year over year date for comparison
Thank you Mike, that works and is nice and simple.
"Mike H" wrote: Hi, Try this =IF(WEEKDAY(A1-364)=2,A1-364,A1-365) Mike "zeroscou" wrote: Hello, I am trying to determine the date of the same Monday last year based on the date of the latest Monday's date. If I just subtract 364 from the current date, I can get the date; however, I think that this formula would create errors if there is a leap year. Thank you, Brian |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Determine year over year date for comparison
Glad I could help
"zeroscou" wrote: Thank you Mike, that works and is nice and simple. "Mike H" wrote: Hi, Try this =IF(WEEKDAY(A1-364)=2,A1-364,A1-365) Mike "zeroscou" wrote: Hello, I am trying to determine the date of the same Monday last year based on the date of the latest Monday's date. If I just subtract 364 from the current date, I can get the date; however, I think that this formula would create errors if there is a leap year. Thank you, Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to determine Fiscal Year | Excel Discussion (Misc queries) | |||
| Monthly Comparison By Year | Charts and Charting in Excel | |||
| How to determine if year is a leap year | Excel Worksheet Functions | |||
| Determine every wednesday based off year | Excel Discussion (Misc queries) | |||
| Showing data per month & year for comparison | Excel Discussion (Misc queries) | |||
Hybrid Mode
