Forum Discussion

Brass Contributor

Jan 24, 2020

Solved

Date Error in Feb 2020

I am using Microsoft Excell on a Mac computer. I have created the attached 4 Week Microsoft Excell Spreadsheet Calendar Template, which includes calendar dates. I use the calendar repetitively as a template. Please note that this year there are 29 days in February. Thus, beginning in cell U16 forward the date is an error. Can you provide a fix, so that going forward I will not have any errors on the template?

Thank You.

Richard

SergeiBaklan
Jan 25, 2020
Richard_James , glad to help

14 Replies

SergeiBaklan
Diamond Contributor
Jan 24, 2020
Richard_James , it looks like duplicating of https://techcommunity.microsoft.com/t5/excel/calculate-1st-sun-2nd-sun-3rd-sun-4th-sun-and-5th-sun/m-p/1033206

Richard, there is no attachment
- Richard_James
  Brass Contributor
  Jan 24, 2020
  SergeiBaklan
  
  Here it the attachment.
  
  Thanks!
  Richard
  FOUR WEEK SCHEDULE FEB. 16-MAR. 14 2020 Ver. Date 1.23.xlsx21 KB
  - SergeiBaklan
    Diamond Contributor
    Jan 24, 2020
    Richard_James
    
    Sorry, but I didn't catch what is an error - dates are calculated correctly.

Resources