Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MGC MGC is offline
external usenet poster
 
Posts: 31
Default Function to lookup date on tab in excel and populate date on calen

I have created a workbook with a tab for each month. These tabs have various
columns with dates (move in date-column C) followed by columns for a
follow-up date as well as dates 30, 90 and 180 days out from the move in
date. I would like to know if there is any way to populate a calendar in
Excel (the first tab in the workbook) with the resident's name and apt number
which are concatenated in column AA. I would be happy to e-mail my
spreadsheet if that would be helpful.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference betwen Excel Date () Function and System Date Khalil[_2_] Excel Worksheet Functions 2 June 16th 09 01:10 PM
Difference System date and Excel Date function Khalil Excel Worksheet Functions 2 June 16th 09 11:23 AM
Can I get Excel to populate a cell with the soonest date in a rang Jennifer eMe Excel Worksheet Functions 3 April 2nd 08 05:23 AM
how do you auto populate the date in excel? ccb/ws New Users to Excel 2 June 13th 06 07:46 PM
HOW ?Excel chart auto insert /populate a code based on date MikeR-Oz New Users to Excel 6 December 22nd 05 12:16 PM


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"