Hi All
I need help. How to change the date automatically depending on the instructions. If the date of the medical certificate of the Government (MCG) included, automatically private medical certificate (MCP) date will change to the rear on the day before the Government's medical certificate given if the date overlaps
The cell A4 and A5, are you key in manually or get from somewhere else?
Thinking Function IF can solve this.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Cell A needs to dual function use filled manually and automatically. Or I need 2 sheet (sheet 1 filled up the exact date and sheet 2 compilation will be in automatically based on sheet 1)Originally Posted by wenqq3
Change Date-V1.xlsx
Based on your comment, sheet2 copy from sheet1. Please check sheet2, is that okie for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks