L luv2salsa New Member Dec 31, 2014 #1 I have the following formula "=DATE(YEAR(TODAY()),T2,1)" which creates December 2014 in my employee timesheet calendar. How do I updated to show January 2015? I attached the Semi-monthly time sheet. Thank you. Attachments Semi-monthly Time Sheet.xlsx Semi-monthly Time Sheet.xlsx 244.3 KB · Views: 11
I have the following formula "=DATE(YEAR(TODAY()),T2,1)" which creates December 2014 in my employee timesheet calendar. How do I updated to show January 2015? I attached the Semi-monthly time sheet. Thank you.
Somendra Misra Excel Ninja Dec 31, 2014 #2 Hi, It will automatically shift to 2015 from tomorrow. Regards,