| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to add auto remender in worksheet
I have employess that need a TB test every year..I have them listed in my
worksheets and want to have a row at the end of worksheet where it automatically calculates when next TB test is due...ie..11-01-04 first test so next test is due 11-01-05..Which functions would I use? Thanks! -- Joyce |
|
#2
|
|||
|
|||
|
How to add auto remender in worksheet
Assuming your test date isin A4:
=DATE(YEAR(A4)+1,MONTH(A4),DAY(A4)) -- Ian -- "Joyce" wrote in message ... I have employess that need a TB test every year..I have them listed in my worksheets and want to have a row at the end of worksheet where it automatically calculates when next TB test is due...ie..11-01-04 first test so next test is due 11-01-05..Which functions would I use? Thanks! -- Joyce |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Linking cells in a worksheet to other worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
Linear Mode
